excel custom menu
Bob,
Thanks! I built the menu using these code
Set MenuObject = Application.CommandBars(1). _
Controls.Add(Type:=msoControlPopup, _
Befo=PositionOrMacro, _
Temporary:=False)
It is showing fine until I click on a chart in the
worksheet and the menu is not longer showing. If I click
somewhere else, the menu is back.
Any idea?
-----Original Message-----
Lynn,
Why don't you assign the menu controls to the macros in
the workbook open
event code, or even build the menu in there, so that it
dynamically changes
with the worksheet?
--
HTH
Bob Phillips
"Lynn" wrote in message
...
Hi anyone,
I create an excel file, named measure.xls with custom
menu
called pace. A few simple drop-down menu bar were
assigned to this pace menu. Each menu bar is assigned
to
an macro such as view a selected chart. Save
measure.xls
to c:\ drive. Test, it works fine. I save this excel
file to another drive such as d:, my menu in the new
excel
worksheet stops working, it said worksheet is already
open. I check each menu bar in this excel file (in d:
drive), it seems that the macros are assigned to
c:\measure.xls worksheet macro.
How can I make it work? How can I create a menu in a
worksheet and then save it to a different location and
the
menu is still working?
Can someone help me? I appreciate.
Lynn
.
|