G Guest Nov 21, 2005 #1 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?
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 Nov 21, 2005 #2 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
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
