toolbar macros that dont change when worksheet is renamed

[marlin40]

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?

 

[Bernie Deitrick]

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