Right click unprotect in 2002

jgoulart · Apr 24th, 2002, 10:53 PM

I have a workbook and worksheet that are protected and when I right click on a cell that doesn't have a before_right_click macro attached to it unprotects the worksheet. Am I missing something or is this the way 2002 works? I checked to make sure that the cell was locked and protected before I right clicked and when I did right click the dropdown list came down and gave me full editing capability and when I left clicked it after that I had full view of a once hidden cell.

jgoulart · Apr 24th, 2002, 10:59 PM

Sorry about that last statement. I have created my own problem by exiting the sub without reprotecting it if it didn't fall within my target range. Hopefully I won't waste any more of your time without investigating things a little more thoroughly.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 10:53 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	I have a workbook and worksheet that are protected and when I right click on a cell that doesn't have a before_right_click macro attached to it unprotects the worksheet. Am I missing something or is this the way 2002 works? I checked to make sure that the cell was locked and protected before I right clicked and when I did right click the dropdown list came down and gave me full editing capability and when I left clicked it after that I had full view of a once hidden cell.

Apr 24th, 2002, 10:59 PM	#2
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	Sorry about that last statement. I have created my own problem by exiting the sub without reprotecting it if it didn't fall within my target range. Hopefully I won't waste any more of your time without investigating things a little more thoroughly.