toolbar macros that dont change when worksheet is renamed

M

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?
 
B

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
 
Top