can I rename sheets without depending on cells ?

tubrak

Board Regular
Joined
May 30, 2021
Messages
68
Office Version
  1. 2019
Platform
  1. Windows
hello
An idea is running through my head, I don't know if it can be implemented. The idea is I have about 10 worksheets named as follows (first, import, export, export return, import return, result1,result2,result3,result4,result5)
What I want is when I click on the macro, the names of the sheets that contain the word result change to first1, import1, export1, export return1, import return1 and when open file , the sheet names are returned to what they were before result1,2... befor run the macro
I don't want depend for specific cells to rename the sheets .
and if that's impossible do that without using cells then I accept this solution by cells
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

pliskers

Active Member
Joined
Sep 26, 2002
Messages
422
Office Version
  1. 2016
Platform
  1. Windows
The simplest suggestion I can think of is to record the renaming of the worksheet tabs in one macro, and to create a second macro that renames the tabs back to the original names and have that second one run automatically as a Workbook_Open procedure.

1632407150708.png
 

Forum statistics

Threads
1,143,637
Messages
5,719,961
Members
422,251
Latest member
bonebreaker100

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top