ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Password Protect Excel Options (https://www.excelbanter.com/excel-discussion-misc-queries/239106-password-protect-excel-options.html)

Ed O'Brien

Password Protect Excel Options
 
I have several identical workbooks with sheets that individuals complete
daily. Those areas of the sheets they do not complete are locked - so they
can only enter required data in specified cells.

The Excel Options also have settings we wish to keep out of reach, so to
speak.

Does anyone know if there is a means to password protect the Excel Options?

TIA for any help.

Ed



Jim Thomlinson

Password Protect Excel Options
 
Some options are sheet specific and others are application level options so
the answer is no you can not protect the options...
--
HTH...

Jim Thomlinson


"Ed O'Brien" wrote:

I have several identical workbooks with sheets that individuals complete
daily. Those areas of the sheets they do not complete are locked - so they
can only enter required data in specified cells.

The Excel Options also have settings we wish to keep out of reach, so to
speak.

Does anyone know if there is a means to password protect the Excel Options?

TIA for any help.

Ed





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

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