before right click problem

[Gary Keramidas]

i have a little routine that runs if i user right clicks a certain cell while
the sheet is protected. i have seen 2 pc's where this does not work, the normal
right click menu pops up.

anyone have a guess as to why?

 

[Die_Another_Day]

Does any of the other "Events" work on those pc's?
Application.EnableEvents stays put when you set it there, so if someone
wrote code that set it to "False" it is still false. You can test it
with "?Application.EnableEvents" in the Immediate window.

Charles

 

[Gary Keramidas]

hi charles:

i know it's nothing i wrote, but i guess they could have opened up some other
workbook that set it. but i swear i started excel when i noticed this, but maybe
it was already running and i just loaded my workbook.

thanks, i think i'll just make sure i enable them in my code.

--


Gary

Does any of the other "Events" work on those pc's?
Application.EnableEvents stays put when you set it there, so if someone
wrote code that set it to "False" it is still false. You can test it
with "?Application.EnableEvents" in the Immediate window.

Charles

 

[Die_Another_Day]

Gary, re-starting xl does not reset EnableEvents, that's why it's
important to remember to set it back true.

Charles

hi charles:

i know it's nothing i wrote, but i guess they could have opened up some other
workbook that set it. but i swear i started excel when i noticed this, but maybe
it was already running and i just loaded my workbook.

thanks, i think i'll just make sure i enable them in my code.

 

[Dave Peterson]

You sure?

I'd check that one more time.

Gary, re-starting xl does not reset EnableEvents, that's why it's
important to remember to set it back true.

Charles

 

[Die_Another_Day]

I stand corrected. Restarting excel does reset the events. I read
somewhere that it did not. My mistake.

Charles