Macro code amendent for changing worksheet name required

[mingali]

Hi,

Last time, DonkeyOte wrote a macro for me for changing worksheet name. Now the worksheets sequence have changed and so, the macro required slight amendment to reflect this change. I tried to amend it without success. I wish someone can assist me to amend the script to suit the current workbook.

Please Login or Register  to view this content.

Now, a new worksheet "Worksheet 1" is added to the 2nd worksheet. so basically, i need to those names shown in "Menu" to be named in the worksheet eg worksheet 3 to be named as "!", worksheet 4 as "AIR" etc.


Thanks alot.