Security Setting

T

Tarig

Hi

How can I set security on an excel template so that usera are only allowed
to click and change on specific cells while other cells are disabled.

Thanks
 
R

Roger Govier

Hi

All cells in Excel are Locked by default.
This means when Sheet Protection is enabled, those cells will be locked.

First use Format>Cells>Protection and remove the Locked check mark from the
cells you wish people to use.
Then apply Tools>Protection>Protect sheet

Be aware that Worksheet protection can be overcome, even if you set a
password, if users are determined to remove it.
 
Top