+ Reply to Thread
Results 1 to 3 of 3

Renaming Sheets

  1. #1
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    144

    Renaming Sheets

    I'm new to VBA coding so please be patient with my question.

    I have inserted a button which is assigned to a query. Button should unprotect a specific sheet and then refresh. I want to also change sheet names based on a cell value (F2 "Review Date") but only on specific sheets. I have added a module to do this but not sure if this is the process or my code is incorrect. What am I doing incorrectly?

    Sheet protect password is "123"
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    1,991

    Re: Renaming Sheets

    I just added your first macro in your second macro and it worked well.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    144

    Re: Renaming Sheets

    If I add additional sheets to also reflect sheet name as per cell value, how would I adjust this code? Would I then continue to build inside module 2?

+ 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] Renaming Sheets
    By omagoodness in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-03-2020, 06:43 PM
  2. [SOLVED] Renaming Sheets 1 to 31
    By greveg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2013, 06:46 AM
  3. Renaming Sheets
    By Melissa9 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-12-2012, 12:52 PM
  4. renaming sheets as A2
    By scottyboy5588 in forum Excel General
    Replies: 1
    Last Post: 04-01-2008, 04:42 AM
  5. Renaming Sheets
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2008, 03:25 PM
  6. Renaming sheets
    By Peter1999 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2007, 10:29 AM
  7. [SOLVED] renaming sheets
    By Kjeldc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2006, 07:30 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