Macro to make tab name equal cell content

[sunirone]

A workbook that I use has 58 tabs. On each tab the customer name is on cell B2. I need a macro to make the name of each tab equal the customer name in cell B2. Please help. Note - I dont know much about macros, please provide the steps on how to introduce the macro. THanks in advance for the help!

[ajryan88]

Hi,

Firstly open the VBA editor (Alt+F11), and go to "Insert --> "Module". Then paste the following code:

Please Login or Register  to view this content.

To use this macro, go to the "Developer" tab on the Excel 2007 ribbon (this needs to be enabled in Excel Options if you can't see this tab, as it is disabled by default). Under the "Code" group, click on "Macros", then select "RenameSheets" from the list and click on "Options...". In this dialog you will be able to assign a keyboard shortcut to activate your macro. Once you have done this click OK/Close until you are back to the workbook, then press your keyboard shortcut to see the macro work.

Hope this helps

[sunirone]

Thanks ajryan88. That worked. Appreciate the help.

[ajryan88]

No problems!

Please don't forget to click on the * next to my post to say thanks

Have a great day