Macro in toolbar - how to use forever

  • Thread starter Thread starter Kathrine J Wathne
  • Start date Start date
K

Kathrine J Wathne

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!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
How to call module function or sub from the Add In? 3
How to force macros refer to ActiveWorkbook 2
Problem in adding macro to ribbon through Add-in 7
How do I refer to a custom toolbar button? 3
Run Macro on All Sheets Q 8
Macro to Combine Data from Multiple Sheets with Cell References 4
Error Message - Macro to Unlink MS Queries from Workbook 0

Back
Top