LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
jg jg is offline
external usenet poster
 
Posts: 42
Default Protection Macro Causes All Workbooks to Be Locked

I've posted this before, just forgot the answer...sorry.

One of our programmers created a macro to prevent insert option, save as
option etc. for a specific workbook.

The macro has, however, now infected all workbooks. Even if you create a
brand new workbook, all of these options are grayed out.

I know there is a reset code. Could someone share it with me. Thanks.
 
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
Locked cells are still able to be selected with proper protection Jesse Excel Discussion (Misc queries) 2 March 2nd 10 04:06 PM
Protection & Locked issue ah Excel Discussion (Misc queries) 1 August 20th 08 08:30 AM
Hiding rows with cells locked using format protection lock functio John G.[_2_] Excel Discussion (Misc queries) 3 May 7th 08 12:14 AM
Setting a workbooks protection/read only/locked Jason Kontkanen Excel Programming 1 September 23rd 05 04:29 PM
setting Select (Un)Locked Cells in Worksheet Protection rbyte Excel Programming 1 September 26th 04 05:14 AM


All times are GMT +1. The time now is 07:50 AM.

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

About Us

"It's about Microsoft Excel"