View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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