Thank you!
A problem is that when a user click on a chart in the
workbook, the menu is no longer showing on the
commmandbar. Until user clicks somewhere else other than
the chart, the menu is back.
Any idea?
-----Original Message-----
This file might be a help:
http://www.bygsoftware.com/examples/.../MenuActiveWbD
emo.zip
It's in the "Menu Routines" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains VBA code that will activate a menu only when
the workbook it is
in is active.
The code is open and commented.
All you have to do is substitute your own routine names
for those in the
demo.
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
http://www.bygsoftware.com/saveandbackup.htm
"The Excel Auditor" and "Byg Tools for VBA"
"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
.