Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menu bar doesn't work
I am currently doing version testing on an Excel template that will b distributed. It was developed in Excel 2000, and I am currentl testing it in Excel 2002. The template has a custom menu bar that i created when the worksheet is opened. This menu bar does not appear t be working properly in Excel 2002. All buttons of the menu bar caus Excel to open a new copy of the same template, and I am prompted wit the standard pop-up to enable or disable macros. When I run the macro via the standard menu bar Tools -- Macros, all of them work fine. Th problem only seems to occur when I try to run the macros via buttons o a custom menu bar. As an experiment, I also tried creating a button o a worksheet and attaching one of the macros to that button. Well, whe I click on that button the same problem occurs as with the custom men bar (Excel tries to open another copy of the same worksheet). suspect this has something to do with a secruity setting or something. Please help!! I am at a loss for a solution or workaround. Thanks i advance for any assistanc -- cristin ----------------------------------------------------------------------- cristina's Profile: http://www.excelforum.com/member.php...fo&userid=1467 View this thread: http://www.excelforum.com/showthread.php?threadid=26295 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menu bar doesn't work
What has worked for me is creating a custom add-in that includes th custom menu creation on open , deletion on exit. Have you tried thi avenue -- bdcris ----------------------------------------------------------------------- bdcrisp's Profile: http://www.excelforum.com/member.php...nfo&userid=356 View this thread: http://www.excelforum.com/showthread.php?threadid=26295 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menu bar doesn't work
In addition to this approach, which IMO is much better than attaching a toolbar you should make
sure the .OnAction property of the buttons includes the workbook name as a prefix to the procedure to be run. This is how I do this: .OnAction = ThisWorkbook.Name & "!ProcedureToRun" - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bdcrisp wrote: What has worked for me is creating a custom add-in that includes the custom menu creation on open , deletion on exit. Have you tried this avenue? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Menu | Excel Programming | |||
Custom Menu Bar | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming | |||
Custom Menu | Excel Programming | |||
Custom Menu | Excel Programming |