Protect but allow changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top