ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Locking certain cells (https://www.excelbanter.com/excel-discussion-misc-queries/46270-locking-certain-cells.html)

Scott

Locking certain cells
 
I have an expense reporting template which I have locked certain cells that I
do not want changed while allowing input into other cells. This is under the
tools functions but its not coming to me right away how I did this. The
users do not need to use any passwords --its just certain cells are read-only
and cannot be changed unless unlocked. How'd I do this I need to update?

Scott

Disregard- figured it out again

"Scott" wrote:

I have an expense reporting template which I have locked certain cells that I
do not want changed while allowing input into other cells. This is under the
tools functions but its not coming to me right away how I did this. The
users do not need to use any passwords --its just certain cells are read-only
and cannot be changed unless unlocked. How'd I do this I need to update?



All times are GMT +1. The time now is 01:16 PM.

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