ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I lock some fields but allow editing for others in excel (https://www.excelbanter.com/excel-discussion-misc-queries/60089-how-do-i-lock-some-fields-but-allow-editing-others-excel.html)

S.Sharif

How do I lock some fields but allow editing for others in excel
 
I am creating a form using excel at which certain fields of the form, editing
is prohibited. Users then wont be able to change the locked values. Editing
is allowed for other fields.

JCM

How do I lock some fields but allow editing for others in excel
 
Under the format cells (ctrl "1"), then click the protection tab. You can
lock or unlock the cell. This is activated afterwards by Tools / Protection

"S.Sharif" wrote:

I am creating a form using excel at which certain fields of the form, editing
is prohibited. Users then wont be able to change the locked values. Editing
is allowed for other fields.



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

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