+ Reply to Thread
Results 1 to 6 of 6

Rename Sheet names from values in another sheet

  1. #1
    Registered User
    Join Date
    05-02-2005
    Posts
    65

    Rename Sheet names from values in another sheet

    Hello,

    I have a a Sheet called "Master Setup" that I would have a list of cells (cells F1 through F12) that I would like to use to rename 12 specific Sheets (Excel Objects Sheet4 thru Sheet15); i.e. Sheet4 to be renamed by value in ='Master Setup'!F1, Sheet5 to be renamed by value in = 'Master Setup'!F2, Sheet6 to be renamed by value in = 'Master Setup'!F3, etc.

    I am a beginner (at best) with VBA. I have seen some other examples in the forum, but I am note sure if they fit.

    Any suggestions or examples would be great! Thank you in advance for your help!!!

    Jim

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Rename Sheet names from values in another sheet

    If the sheets you want to rename are called Sheet4, Sheet5 etc. then you could try this:
    Please Login or Register  to view this content.
    If they're not named Sheet4, Sheet5 etc. but they are the 4th to 15th sheet in order then you could try this:
    Please Login or Register  to view this content.
    Hope that helps.

    BSB
    Last edited by BadlySpelledBuoy; 03-28-2021 at 02:30 AM.

  3. #3
    Registered User
    Join Date
    05-02-2005
    Posts
    65

    Re: Rename Sheet names from values in another sheet

    Tried both of the examples. Received Compile Error: Invalid Outside procedure.

    Thoughts?
    Thanks,
    Jim

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Rename Sheet names from values in another sheet

    Do you have the exact wording that BSB gave you? Otherwise copy ALL code you have and paste here for helpers to see.

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Rename Sheet names from values in another sheet

    As jolivanes suggests, posting your code will help us diagnose the issue.
    Alternatively, attach the workbook.

    BSB

  6. #6
    Registered User
    Join Date
    05-02-2005
    Posts
    65

    Re: Rename Sheet names from values in another sheet

    Thank you BSB and jolivanes. The code does work. When I pasted, some other junk got in which caused the errors. Once I deleted, it worked like a charm. Thanks you again for your help!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Rename 2 sheets from cell values from non-active sheet
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2019, 11:51 AM
  2. [SOLVED] macro to rename sheet as per workbook names
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-07-2019, 02:39 PM
  3. Replies: 1
    Last Post: 07-04-2015, 06:25 AM
  4. Copy certain info in one sheet to a new sheet to a different area and rename new sheet
    By Elmarie_Potgieter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2013, 05:34 AM
  5. Replies: 5
    Last Post: 01-25-2012, 12:31 PM
  6. rename/trim sheet names
    By longhorn23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-27-2010, 12:32 PM
  7. Rename folders using values from sheet
    By cjconnor24 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2009, 05:10 AM

Tags for this Thread

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