how to continually rename tab from cell in another sheet

[cvmelkus]

I need code to be able to rename a tab, possibly frequently, from a cell on another sheet.

So if tab to be renamed is 'sheet1' intially, be able to change it to 'abc', then possibly later again to 'cde', etc. Alll using a cell on a separate input sheet.

thanks !!

[mikerickson]

If sheet being renames has the code name Sheet1 and the cell determining the name is Sheet2!$A$1 then putting this code in the ThisWorkbook code module should work.

Please Login or Register  to view this content.

[cvmelkus]

thanks for quick reply!!! works great!

How might I add additional(different) input cells to modify (different) additional tabs?