 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006A 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 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)  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.