ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   toolbar macros that dont change when worksheet is renamed (https://www.excelbanter.com/new-users-excel/56532-toolbar-macros-dont-change-when-worksheet-renamed.html)

marlin40

toolbar macros that dont change when worksheet is renamed
 
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

toolbar macros that dont change when 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?





All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com