Question

  • Thread starter Thread starter Michael Lam
  • Start date Start date
M

Michael Lam

How to protect a excel worksheet from amendment(the format and formula set
inside the sheet) but allow the user keyin data and save without password


Michael Lam
 
Hi Michael

All cells on a Worksheet are Lockd by default, Format>Cells>Protection
but this has no effect until you Protect the sheet, ToolsProtect>Protect
Sheet.

To lock all formulae cells only, push Ctrl+A then go to
Format>Cells>Protection and Uncheck the "Locked" checkbox and Ok. Now
push F5 (to show the GoTo Dialog) and click Special and check Formulas
and OK. Now go back to Format>Cells>Protection and Check the "Locked"
checkbox and Ok. Now protect the sheet.

*** Sent via http://www.automationtools.com ***
Add a newsgroup interface to your website today.
 
thx
"Dave Hawley" <[email protected]> ¦b¶l¥ó
¤¤¼¶¼g...
Hi Michael

All cells on a Worksheet are Lockd by default, Format>Cells>Protection
but this has no effect until you Protect the sheet, ToolsProtect>Protect
Sheet.

To lock all formulae cells only, push Ctrl+A then go to
Format>Cells>Protection and Uncheck the "Locked" checkbox and Ok. Now
push F5 (to show the GoTo Dialog) and click Special and check Formulas
and OK. Now go back to Format>Cells>Protection and Check the "Locked"
checkbox and Ok. Now protect the sheet.

*** Sent via http://www.automationtools.com ***
Add a newsgroup interface to your website today.
 
Back
Top