A Worksheet Protection Question

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

Guest

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