Workspace limited?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 29 Oct 2006 14:43 GMT

I have a excel document where i can select cells to collom K. Now i want
to change data in collom M. If i turn the sheet protection of (the
password protection) i still don`t get i the area i want. Does anybody
know how i can solve this?

Signature

Using Opera's revolutionary e-mail client: http://wwc.opera.com/mail/

Reply to this Message

Ken Wright - 29 Oct 2006 17:38 GMT

A bit more data might be helpful? Can you see Column M, but can't select
it, or what exactly is the issue?

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

>I have a excel document where i can select cells to collom K. Now i want
>to change data in collom M. If i turn the sheet protection of (the
>password protection) i still don`t get i the area i want. Does anybody
>know how i can solve this?

Reply to this Message

Dennis - 29 Oct 2006 19:49 GMT

> A bit more data might be helpful? Can you see Column M, but can't select
> it, or what exactly is the issue?

Yes i can see it but can`t select. The data i want to change is what i see
in a list from a listbox. The listbox is getting the data from the cells i
can`t select.

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply to this Message

Ken Wright - 30 Oct 2006 09:43 GMT

If you have turned off Sheet protection, ie Tools / Protection / Unprotect
sheet, then do you have any macros running at all. Does it prompt youy to
enable macros when you start the file (I'm assuming you wouldn't have
security set to low such that it wouldn't)

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)

> > A bit more data might be helpful? Can you see Column M, but can't select
> > it, or what exactly is the issue?
> >
> Yes i can see it but can`t select. The data i want to change is what i see
> in a list from a listbox. The listbox is getting the data from the cells i
> can`t select.

Reply to this Message