ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   lock cells for input (https://www.excelbanter.com/setting-up-configuration-excel/100036-lock-cells-input.html)

Khoshravan

lock cells for input
 
There was a command, protecting cells from unwated edit.
I thought it is in options or cells, but I couldn't find.
Do you where is it?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

Stefi

lock cells for input
 
First make sure in Cell formatting/Protection tab that cells you want to
protect are Locked and cells you want to allow to edit are unlocked. Then
Tools/Protection/Protect sheet!

Regards,
Stefi


€˛Khoshravan€¯ ezt Ć*rta:

There was a command, protecting cells from unwated edit.
I thought it is in options or cells, but I couldn't find.
Do you where is it?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan



All times are GMT +1. The time now is 10:23 PM.

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