toolbar macros that dont change when worksheet is renamed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i create a toolbar that the macros run on the active worksheet and the
macro addresses don't change when the worksheet is renamed?
 
Store your code in your personal.xls, and write the code to work on the activesheet, the selection,
or some other dynamic range. Posting your code would be a good start....

HTH,
Bernie
MS Excel MVP
 
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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro for renaming worksheets 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
If statement 3
Rename Sheet from a cell value 3
How to call module function or sub from the Add In? 3
Attached Toolbars Macros 4
Macro coding 3

Back
Top