Renaming multiple sheets in a workbook [Closed]

Question

Renaming multiple sheets in a workbook [Closed]

Report

rev - May 19, 2017 at 03:19 AM
vcoolio

Posts: 1285
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: April 10, 2021

- May 19, 2017 at 08:13 AM

Hello,
I have workbook with more than 50 sheets.. I would like to rename all sheets with workbook name. Something like workbook.sheet1,workbook.sheet 2 ....I just want the name of the workbook in the sheets name.. kindly help me to rename the sheets.. I tried manual method and vb codes but it is not working out. I am new to vb macros and thus I was not successful. Please help me to solve this issue.

Renaming multiple sheets in a workbook
Excel vba rename multiple sheets based on cell value - How-To - Excel
Vba copy multiple sheets to another workbook - How-To - Excel
I want to retrieve value from multiple sheets of same workbook ✓ - Forum - Excel
Rename multiple sheets in excel vba ✓ - Forum - Excel
Macro to rename sheets based off cell value - Forum - Excel

1 reply

Ask a question

vcoolio · Answer 1 · 2017-05-19T08:13:25-0400

Answer 1 / 1

vcoolio

Posts: 1285
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: April 10, 2021

224
May 19, 2017 at 08:13 AM

Hello Rev,

Have a look at the following link:-

https://ccm.net/forum/affich-419062-excel-macro-rename-all-worksheets

If you want to add the workbook name, you'll only need to adjust this line:-

Sheets(iSheetCount).Name = iSheetCount

For example, if your workbook is named Fred, then alter the line as follows:-

Sheets(iSheetCount).Name = "Fred, Sheet" & iSheetCount

Your worksheet tabs should then look like this:-

"Fred, Sheet1", "Fred, Sheet2" etc......

Cheerio,
vcoolio.

Renaming multiple sheets in a workbook [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!