+ Reply to Thread
Results 1 to 3 of 3

Macro assigned to button with change of tab name

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    399

    Macro assigned to button with change of tab name

    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?
    Attached Files Attached Files
    Last edited by Wskip49; 06-20-2012 at 10:52 AM. Reason: Solved

  2. #2
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: Macro assigned to button with change of tab name

    If you use the sheet number as in " Sheet2.Select" then changing the sheet tab name will not matter.

  3. #3
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    399

    Re: Macro assigned to button with change of tab name

    Thank you so much. I learned something today.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1