Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
toolbar macro for esp. worksheet
Hello,
I'm trying to coustumase a tool bar to have only the kind of command buttons that I need and some are actualy use to open a userform within a template worksheet, and untile I close that workbook, works find but once I saveclose it, the template lose all conection to the macro. now the macro is only conectet to the save worksheet I close early. Eny help will be very much apreciated. Mauricio R. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
toolbar macro for esp. worksheet
Mauricio
The way that I handle that problem is to create the toolbar in code when the workbook opens and delete it when the workbook closes. That way, the buttons will always point to the macros in that workbook. For some workbooks, I use the Activate and Deactivate events instead of the Open and BeforeClose events because I may have more than one workbook open that's based on the same template. Post back if you need help creating the toolbars in VBA. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Mauricio" wrote in message ... Hello, I'm trying to coustumase a tool bar to have only the kind of command buttons that I need and some are actualy use to open a userform within a template worksheet, and untile I close that workbook, works find but once I saveclose it, the template lose all conection to the macro. now the macro is only conectet to the save worksheet I close early. Eny help will be very much apreciated. Mauricio R. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TOOLBAR FOR A MACRO | Excel Discussion (Misc queries) | |||
Save Macro and Custom Toolbar in Worksheet | Excel Discussion (Misc queries) | |||
macro in toolbar | Excel Discussion (Misc queries) | |||
macro toolbar | Excel Discussion (Misc queries) | |||
How do I move my worksheet from under the toolbar? | Excel Discussion (Misc queries) |