+ Reply to Thread
Results 1 to 3 of 3

Sheets named after month

  1. #1
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    118

    Sheets named after month

    Hello, simple question.

    I have a code that creates 12 sheets and name them after each month.

    The thing is i have excel in English and the people that are gonna use this have some in English and some in other language.

    Is there a way to tell excel to change the sheet name depending on the language of the app?

    Regards
    Leandro Melo

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Sheets named after month

    Maybe instead of using the month name, you could use a format like this:

    yyyy-mm

    so that will look the same to everyone.

    Hope this helps.

    Pete

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Sheets named after month

    Perhaps these links can assist...Creating own code by joining info from both...
    https://forums.windowssecrets.com/sh...ed-on-Language
    https://www.mrexcel.com/forum/excel-...-language.html
    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 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] Compare cells to named range and create new sheets using related named range
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-10-2015, 03:35 PM
  2. [SOLVED] Renaming Sheets with present month, all dates of that particular month
    By laansesu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2015, 08:43 AM
  3. Expanding code from working on one named sheet to multiple named sheets
    By BryanD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2014, 01:26 PM
  4. Mastersheet, auto input named rows onto other named sheets
    By Chalkie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 12:33 PM
  5. [SOLVED] open worksheet based on month to specific sheet named after month and hide rest
    By ianmcw in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2014, 10:19 PM
  6. [SOLVED] Adding Sheets - New Sheets to be named a specific cell within Each Sheet
    By Ryan Gomez in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-25-2013, 01:22 PM
  7. [SOLVED] Macro for filter on protected workbook that works for all sheets, no matter what sheets are named?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2006, 02:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1