ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I protect a Work sheet so a user can only alter certain cel (https://www.excelbanter.com/excel-worksheet-functions/112595-how-do-i-protect-work-sheet-so-user-can-only-alter-certain-cel.html)

joel

How do I protect a Work sheet so a user can only alter certain cel
 
Hi I have created a workksheet that is to be used as a form when I eventually
save it as a template. There is only certains cells which I would like them
to be able to change.

How do I go about this

REgards Joel
--
N/A

vezerid

How do I protect a Work sheet so a user can only alter certain cel
 
Joel,

First you select all cells that you want to allow changes.
Format|Cells|Protection, set the Locked option to false.

Then Tools|ProtectionProtect Sheet

HTH
Kostis Vezerides


Joel wrote:
Hi I have created a workksheet that is to be used as a form when I eventually
save it as a template. There is only certains cells which I would like them
to be able to change.

How do I go about this

REgards Joel
--
N/A




All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com