+ Reply to Thread
Results 1 to 19 of 19

How can I change sheet tab name automatically?

  1. 05-12-2017, 05:54 AM #1
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    How can I change sheet tab name automatically?

    I have made daily sales report in excel with some of Macros, I am taking report using date filter. Now, I want to rename the sheet name automatically when I
    click Email button, that name should be a date where I am entering in filter cell.

    How can I make it? Thanks in advance.

    Screenshot (1).png
    Reply With QuoteRegister To Reply
  2. 05-12-2017, 06:30 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    Here you go
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 05-12-2017, 06:37 AM #3
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    Re: How can I change sheet tab name automatically?

    i getting error
    Screenshot (2).png
    Reply With QuoteRegister To Reply
  4. 05-12-2017, 06:41 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically? 

    Please Login or Register  to view this content.
    Missed copying the O

    Please Login or Register  to view this content.
    And also is the date in D1
    Reply With QuoteRegister To Reply
  5. 05-12-2017, 06:43 AM #5
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    Re: How can I change sheet tab name automatically?

    when i run the code its change in

    ption Explicit
    Reply With QuoteRegister To Reply
  6. 05-12-2017, 06:46 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    See code in post2
    Reply With QuoteRegister To Reply
  7. 05-12-2017, 06:49 AM #7
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    Re: How can I change sheet tab name automatically?

    ok thanks now its working but when change another date its not coming...
    Last edited by sudbhavani; 05-12-2017 at 06:54 AM.
    Reply With QuoteRegister To Reply
  8. 05-12-2017, 06:58 AM #8
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    Glad I could help....If solved please mark thread as solved and add to reputation...
    Reply With QuoteRegister To Reply
  9. 05-12-2017, 07:01 AM #9
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    Re: How can I change sheet tab name automatically?

    sure.......... but when change another date its not coming...
    Reply With QuoteRegister To Reply
  10. 05-12-2017, 07:08 AM #10
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    Cannot assist without your workbook...Not sure what you have done with my code.
    Think it should be incorporated into your code of [Email Button]
    click Email button, that name should be a date where I am entering in filter cell.
    Reply With QuoteRegister To Reply
  11. 05-12-2017, 07:15 AM #11
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    Re: How can I change sheet tab name automatically?

    here with i have enclosed this workbookPRINT.xlsx.xlsm
    Reply With QuoteRegister To Reply
  12. 05-12-2017, 07:30 AM #12
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    Password protected....
    Reply With QuoteRegister To Reply
  13. 05-12-2017, 07:50 AM #13
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    Re: How can I change sheet tab name automatically?

    ok sorry PRINT.xlsx.xlsm
    Reply With QuoteRegister To Reply
  14. 05-12-2017, 07:57 AM #14
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    Here you go...This renames the sheet to the cell D1.value before it saves and sends:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  15. 05-12-2017, 08:05 AM #15
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    Re: How can I change sheet tab name automatically?

    i getting error when i click the email button
    Screenshot (3).png
    Reply With QuoteRegister To Reply
  16. 05-12-2017, 08:14 AM #16
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    It means that there is two macros with that name.....Check your workbook..Also the workbook has become corrupt as you have renamed it with two extensions....PRINT.xlsx.xlsm

    When running the code it tested fine.
    Reply With QuoteRegister To Reply
  17. 05-12-2017, 08:20 AM #17
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    258

    Re: How can I change sheet tab name automatically?

    ok thanks its working
    Reply With QuoteRegister To Reply
  18. 05-12-2017, 08:22 AM #18
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    Glad you got it working....Pleasure
    Reply With QuoteRegister To Reply
  19. 05-12-2017, 10:07 AM #19
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,300

    Re: How can I change sheet tab name automatically?

    As per Post8
    Glad I could help....If solved please mark thread as solved and add to reputation...
    We spend our personal time to assist......all we ask for is some form of gratitude...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. code change data from sheet 1 will be automatically copied to sheet 2 with conditions
    By hacke.r in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2015, 09:38 PM
  2. [SOLVED] Automatically change sheet number when first sheet is filled in.
    By Bikeman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2014, 04:36 PM
  3. Automatically change references on sheet copy
    By scaffdog845 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2012, 07:49 AM
  4. Automatically Change formatting of Cell in Another Sheet
    By BazzaBoy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2012, 09:39 PM
  5. change data automatically from one sheet to another
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2011, 03:39 PM
  6. automatically change the order of fields in a sheet
    By minrufeng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2005, 05:05 PM
  7. [SOLVED] Automatically run macro on sheet change
    By Steven in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2005, 07:21 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1