before right click problem
 

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?

--


Gary

before right click problem
 

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 wrote:
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?

--


Gary

before right click problem
 

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


"Die_Another_Day" wrote in message
oups.com...
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 wrote:
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?

--


Gary

before right click problem
 

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

Charles

Gary Keramidas wrote:
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


"Die_Another_Day" wrote in message
oups.com...
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 wrote:
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?

--


Gary

before right click problem
 

You sure?

I'd check that one more time.

Die_Another_Day wrote:

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

Charles

Gary Keramidas wrote:
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


"Die_Another_Day" wrote in message
oups.com...
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 wrote:
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?

--


Gary


--

Dave Peterson

before right click problem
 

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

Charles

Dave Peterson wrote:
You sure?

I'd check that one more time.

Die_Another_Day wrote:

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

Charles

Gary Keramidas wrote:
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


"Die_Another_Day" wrote in message
oups.com...
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 wrote:
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?

--


Gary


--

Dave Peterson