Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in toolbar - how to use forever
I have managed to make a toolbar with a personal made macro. However; the
macro seems only to work when I use the worksheet that was open when making the macro. When making new sheets - the macro does not work. H How can I make a macro that will work for every single new worksheet? The toolbar should be universal to all my sheets. Please help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in toolbar - how to use forever
Best thing probably to do is take a look at the code for your macro by going
into the Visual Basic editor. It will probably be stored in "Module 1". If you can't figure it out from there then you might try posting the code back to this group for help. Bob L. "Kathrine J Wathne" wrote in message ... I have managed to make a toolbar with a personal made macro. However; the macro seems only to work when I use the worksheet that was open when making the macro. When making new sheets - the macro does not work. H How can I make a macro that will work for every single new worksheet? The toolbar should be universal to all my sheets. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|