Security Setting

[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

 

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