Protect the formatting

S

Scott

I would like to protect the worksheets from changing the formats. Can
someone advise how to accompany it.

Thanks,

Scott
 
Z

Zorrina

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.
 
D

Dave Peterson

Maybe...

Tools|protection|Protect sheet

If you're using xl2002+, don't select the option that lets the users change
formatting.
 
Top