Rename All Sheets From A List... In One Step

Good day, Nabil, I am trying to follow along but I do not have the same Excel version you have, which I believe is a problem. Our tool bars are different and I also do not have access to visual basic editor. Is there another way to range the a1 column and sheets? Thanks

Thank you bro

What about if you are wanting to do a Date format? I'm failing with this. If I put in alpha characters only it works, but nothing with a date

Hi , would like to ask how to save can use this marco for everyday . ?

Can you see me the code for this? Many thanks

After a few glitches I got it to work.
I was trying to put days of the month, which excel automatically turns into a date, that cannot be a sheet name (no / allowed ).
A couple of extra steps fixing the list and changing it to text and bingo 35 sheets done and rolled over for another month!
I think I watched another of your videos for making a totals page from a range of sheets, so there was a "first", "Last", "totals" and "rename sheets"

Thank you very much, Sir!

Amazing!

How can we make it so that it skips sheets with the name already taken and not give an error

How to change one or moreTabs name or worksheets name in upper Case by vba? my worksheets has 100 nos

it is great, sir

Amazing, you saved my lots of effort hurs.

thank for you

thanks

I've done exactly what was showed in the video which works perfectly however the other formulas I had in my main sheet now shows BLOCKED what does this mean and how do I get around it?

Absolutely AMAZING! Thank you :)

did not work for me. I do not want to rename the tab that has the naming structure or the tab that has the summed up data but instead rename the remaining tabs. for example i have the first tab that will have the collected data represented and then the next subsequent tabs broken down by the day of the month for the entire month.

I am copying multiple sheets in one excel and want rename it.. but due some restrictions I am not supposed to have macro in that main excel sheet.. is there any way that I can have this macro in another workbook and it will rename the sheets in the main excel sheet automatically...

What a fantastic video! Could you provide me and advice how to limit to 30 caracters? I have a list taken from an other cell and it’s more than 30 ( limit for sheet name)

Great work, can you do the VBA for sheet name AND add sheets depending on how many rows contain data?

sir suppose i have list 15 name of sheet so please make vba code to creat sheet as per list if possible

Can I rename worksheet name as workbook?? For single sheet only??
I have number of files in Excel to rename??

I have 12 cells I want to name 12 of the sheets (not all sheets just 12 in the middle of 24. and Cells are spread over 4*3 layout. Cells H5:K8) any thoughts?

What a great clear video! You explain clearly what you do and what it means. That is what is helping many people to understand!

THIS WAS AWESOMEEEEEEEEEEEEEEEEEEEEEEEEEEE! I am so glad I found this video Thank you! I was able to follow your instructions and I renamed 23 tabs in a matter of minutes. Much appreciated! God Bless you!!

Thanks so much!!!

Amazing

Good tutorial ! please how to do when i want to rename sheets N° 2-3-4-5-6-7 only,

An excellent video, explained with much clarity and passion, thanks

Hi Nabil,
Thank you for posting this extremely useful video.
Your VBA explanation was clear & concise.

Great video, but i wondering if I want the sheet where the list of names don't to be named with the code how to do this?

You are great man!! it was extremely helpfull and thanks for quick codding tutorial.

Thank you so match, Sir.

Sir what if we want "name" to be the date... I. E my workbook is named "july, 2021" and want to name sheets by date for every single day. Pls guide

Thank you sir, really it is great class for me.

Sir, what steps in same situation in Google spreadsheets?

Please guide me.

I am from bangladesh. I watch many vedio for this problem.. and finally I can say it's simple and very easier then others. Thanks a lot sir

What if I want to hyperlink at the same time? Thanks the video it's very helpful

Amazing!

Thanks very useful , quick question
once all the sheets have been renamed , can I come back and delete the macro if a) I dont want to rename more sheets in future b) I want to retain a macro free workbook ?

my first tab changed to 9176?? why?

This only worked for the first 5 names, I have 45 names. My first name starts at A4, my i value is 4, right?

Thanks - Enjoy your clear explanation of all the details

THAT IS perfect... thanks a lot man.

Sir it is unable run in excel 2013 , what we have to do? Plz help

Thank you sir from india

hi works great but if you want to update say 5 name out of 100 as soon as the macro hits a sheet name which is the same as it is trying to change it to it stops and errors out.. how can I fix this

Very helpful. Thank you!

Thanks for the lesson, however I am trying to use this format in a workbook in which the naming sheet is the second sheet in the workbook and will only rename sheets after the naming sheet. Can you help me?

Thank you for sharing this, i have been looking to use this function for a week. It works great