ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro in toolbar - how to use forever (https://www.excelbanter.com/excel-programming/314179-macro-toolbar-how-use-forever.html)

Kathrine J Wathne[_2_]

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!



Bob[_62_]

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!





All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com