Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can protect an Excel spreadsheet with a password pascalpinault Excel Discussion (Misc queries) 1 July 30th 09 07:44 PM
Excel - password protect error kori Excel Discussion (Misc queries) 0 May 27th 08 10:29 PM
How do I password protect a workbook in Excel? Elmer Excel Discussion (Misc queries) 4 March 13th 08 06:50 PM
password protect the button in Excel? cfman Excel Discussion (Misc queries) 3 March 2nd 07 09:06 PM
No password protect workbook box in Tools>Options>General MS Excel Discussion (Misc queries) 2 July 16th 05 06:34 AM


All times are GMT +1. The time now is 12:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"