can I rename sheets without depending on cells ?

[tubrak]

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

 

[pliskers]

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.