If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel custom menu
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 . |
Thread Tools | |
Display Modes | |
|
|