Protect but allow changes

[Guest]

Hi All,

I would like to protect a worksheet but allow others to
change column width and format numbers. Is that possible
and how do I do this? Thank you for your help.

Regards

 

[Paul B]

It depends on what version of excel you have, when you protect the sheet
check allow format cells and format columns if you have this option
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Gord Dibben]

If using Excel 2002 or 2003 you have the option when protecting the sheet of
allowing users to do certain operations on the sheet.

Earlier versions would require a macro to unprotect then re-protect the sheet.

ActiveSheet.Unprotect Password:="justme"

'do your stuff

ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True

Gord Dibben Excel MVP

 

[Guest]

Thanks. Unfortunately, I am still using Excel 2000.
Thanks for your help.

 

[Texas Aggie]

couldn't you just format/cells/unlock the area you want left modifiable?

txag