Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Watch to Trap Protected Sheet (Repost)
I am somehow protecting a sheet when I run some code. Can't figure out how I
am doing it. Can I set up a Watch to tell me when/how this is happening? Thanks P.S. There are only two sheets in the file. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Watch to Trap Protected Sheet (Repost)
If ActiveSheet.Protect = True
is protecting your worksheet. I don't believe protect is a property. I'm not sure what the property is to test for a protected sheet. ProtectContents can check to see if the contents of a sheet are protected. Will that work for what you are doing? Otherwise, best advice I can give you is to check VBA help on protection. "ExcelMonkey" wrote: I am somehow protecting a sheet when I run some code. Can't figure out how I am doing it. Can I set up a Watch to tell me when/how this is happening? Thanks P.S. There are only two sheets in the file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trap Sheet Name Change | Excel Programming | |||
How can i trap the rename event of an excel sheet? | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Error trap the renaming of a sheet to an existing one | Excel Programming | |||
Repost:replacing data on a non focused worksheet with calculated data from the same sheet | Excel Programming |