Macro button to move to named tab. How can I assign the tab name to the button. If I change the tab name "Jones" to "Franks" the macro button want work. How can I make the Macro change to the name "Franks" with out going into the Macros?
Macro button to move to named tab. How can I assign the tab name to the button. If I change the tab name "Jones" to "Franks" the macro button want work. How can I make the Macro change to the name "Franks" with out going into the Macros?
Last edited by Wskip49; 06-20-2012 at 10:52 AM. Reason: Solved
If you use the sheet number as in " Sheet2.Select" then changing the sheet tab name will not matter.
Thank you so much. I learned something today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks