S Scott Sep 23, 2008 #1 I would like to protect the worksheets from changing the formats. Can someone advise how to accompany it. Thanks, Scott
I would like to protect the worksheets from changing the formats. Can someone advise how to accompany it. Thanks, Scott
Z Zorrina Sep 23, 2008 #2 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.
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 Sep 23, 2008 #3 Maybe... Tools|protection|Protect sheet If you're using xl2002+, don't select the option that lets the users change formatting.
Maybe... Tools|protection|Protect sheet If you're using xl2002+, don't select the option that lets the users change formatting.
