Watch to Trap Protected Sheet (Repost)

[Guest]

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.

 

[Guest]

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.

 

[Guest]

In looking through help, VBA has the following 3 properties pertaining to
worksheet protection. You could use any or all of these to test for whatever
protection you need to.

ProtectScenarios
ProtectDrawingObjects
ProtectContents

 

[Norman Jones]

Hi ExcelMonkey,

A sheet can only be protected by explicitly invoking the protect method.

So, locate the line (or lines) in you code which contain the word 'protect'
(Edit | Find) and put a watch on the line(s).