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


"marlin40" wrote in message
...
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?