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
|