| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect the formatting
I would like to protect the worksheets from changing the formats. Can
someone advise how to accompany it. Thanks, Scott |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect the formatting
Hi Scott. I am not sure if this will work.
In Excel 2003, on the Tools menu, point to Protection, and click Protect Workbook. In the Protect Workbook dialog box, select the Structure check box. "Scott" wrote: I would like to protect the worksheets from changing the formats. Can someone advise how to accompany it. Thanks, Scott |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect the formatting
Maybe...
Tools|protection|Protect sheet If you're using xl2002+, don't select the option that lets the users change formatting. Scott wrote: I would like to protect the worksheets from changing the formats. Can someone advise how to accompany it. Thanks, Scott -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Protect Sheet - Allow formatting - On MAC | Excel Discussion (Misc queries) | |||
| How do I protect formatting only? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting | Excel Worksheet Functions | |||
| protect formatting | Excel Discussion (Misc queries) | |||
Linear Mode
