View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Worksheet events inactive

David,

I assume when you refer to menus your referring to those created by
yopurself becuase this suggestion doesn't efect normal right-click sheet
menus.

One way this problem can occur is if a macro crashes or stops half way
through with events disabled. For example this would be quite common coding:-

Application.enableevents=false

do something

Application.enableevents=true

As you will see if the macro stops without completing events will be disabled.
I suggest you have a look if you have code that does this on opening a
workbook.

Mike

"David" wrote:

On opening one of my workbooks this morning I found that all the worksheet
events were inactive (BeforeRightClick, Activate etc). As a consequence my
popup menus wouldn't appear (BeforeRightClick) neither would toolbars appear
and disappear in response to the Activate and Deactivate events. After I
closed the workbook and reopened it, there was no change but things got back
to normal after I had shut down Excel and reopened it. All is now well but I
am puzzled what might have caused the problem. ANy suggestions?
--
David Stevenson, UK