| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Protection | Excel Discussion (Misc queries) | |||
| Worksheet protection problem | Excel Discussion (Misc queries) | |||
| Customizing Worksheet Menu Bar question. Help! | Excel Discussion (Misc queries) | |||
| Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Hybrid Mode
