D
Dave Unger
Hello everyone,
Has anyone else run into this one?
With Sheet1 active, I run the following bit of code:
Sheet2.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheet2.EnableSelection = xlUnlockedCells
Besides Sheet2 getting protected, Sheet1 also seems to get a
“phantom” protection, and I can’t select any of its locked cells. If
I persist in trying, Excel locks up, and goes into never never land,
and I need to use Ctrl Alt Del to break out of it.
I get no indication that Sheet1 is actually protected, and un-
selecting, then re-selecting Sheet1 puts everything right. Also, if
Sheet2 is active while running the procedure, all is well
If I run this under XL97, I have no problem whatsoever, only with
XL2007. I’m wondering if any other later than XL97 versions are also
experiencing this.
I’ve un-installed/re-installed XL2007 to no avail, and so far have
been unable to find any mention of this in the groups, Microsoft,
etc. Any light that someone can shed on this is most appreciated.
Regards,
DaveU
Has anyone else run into this one?
With Sheet1 active, I run the following bit of code:
Sheet2.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheet2.EnableSelection = xlUnlockedCells
Besides Sheet2 getting protected, Sheet1 also seems to get a
“phantom” protection, and I can’t select any of its locked cells. If
I persist in trying, Excel locks up, and goes into never never land,
and I need to use Ctrl Alt Del to break out of it.
I get no indication that Sheet1 is actually protected, and un-
selecting, then re-selecting Sheet1 puts everything right. Also, if
Sheet2 is active while running the procedure, all is well
If I run this under XL97, I have no problem whatsoever, only with
XL2007. I’m wondering if any other later than XL97 versions are also
experiencing this.
I’ve un-installed/re-installed XL2007 to no avail, and so far have
been unable to find any mention of this in the groups, Microsoft,
etc. Any light that someone can shed on this is most appreciated.
Regards,
DaveU