A Worksheet Protection Question

[PA]

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

 

[Nick Hodge]

Paul

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

Go to tools>protection>protect sheet and check format cells under 'allow
users of this workbook to:' list

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk