+ 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
    Excel 2007
    Posts
    17,308

    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
    Posts
    5,510

    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)

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