ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I lock a cell in excel file ? (https://www.excelbanter.com/excel-programming/349052-how-do-i-lock-cell-excel-file.html)

Raja, London

How do I lock a cell in excel file ?
 
Hi,
I want to lock few cells which carries formulae, so that data entry person
do not make any changes. He or she only enters the data.



Tom Ogilvy

How do I lock a cell in excel file ?
 
the default setting for cells is locked. However, this is not enforced
until the worksheet is protected. Have you unlocked the cells that you want
the user to have access to, then protected the sheet?

--
Regards,
Tom Ogilvy


<Raja; "London" <Raja, wrote in message
...
Hi,
I want to lock few cells which carries formulae, so that data entry person
do not make any changes. He or she only enters the data.






All times are GMT +1. The time now is 09:54 AM.

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