A Worksheet Protection Question
 

How can I protect a worksheet so that any user can do anything desired, except
change the formatting. Using Excel 2002.
Thanks for any suggestions
Paul

A Worksheet Protection Question
 

Paul

I've only got 2003 and 2007 on this machine, but I think this applies to XP
(2002)

Go to toolsprotectionprotect sheet and check format cells under 'allow
users of this workbook to:' list

Remember protection is a two stage process (locking the cells under
formatcells...Protection. this is the default and then protect the sheet,
with or without a password)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"PA" wrote in message
...
How can I protect a worksheet so that any user can do anything desired,
except
change the formatting. Using Excel 2002.
Thanks for any suggestions
Paul