MS Excel 2007

[Greg Masters]

• Shared password-protected Workbook on common drive
• Protected sheets
• Some columns/cells on each sheet are user editable; some are not.
• I'm the 'owner'

Just added a column. I need to allow all users to be able to edit the data in the new column without entering an additional password.

How the feck do I switch off the column protection to allow users to edit cell values?



Greg

 

[richie]

from memory, long time ago, format, cells, protection...

 

[Greg Masters]

from memory, long time ago, format, cells, protection...

I'm obliged - that's what I needed.

Unfortunately in v.2007, the 'format, cells' bit is nowhere near the 'review, protect worksheet' commands.



Job done!

Thanks

Greg

 

[richie]

I'm obliged - that's what I needed.

Unfortunately in v.2007, the 'format, cells' bit is nowhere near the 'review, protect worksheet' commands.



Job done!

Thanks

Greg

Glad it worked, and that my memory still works...