Excel Tabs

[fast4522]

Has anyone been able to change the Tabs names by what is in a different cell location? I load parsed Bris Singles into Excel and thought it would be good if I could rename tabs with the data I load.

[NatteringNeighBob]

Has anyone been able to change the Tabs names by what is in a different cell location? I load parsed Bris Singles into Excel and thought it would be good if I could rename tabs with the data I load.


The following web page contains sample code for renaming all of the worksheets in a workbook, based on the contents of a cell. With a few tweaks, it may work for you.

http://it.toolbox.com/wiki/index.php/Excel_Macro_to_Rename_Worksheet_Tabs

[raybo]

Has anyone been able to change the Tabs names by what is in a different cell location? I load parsed Bris Singles into Excel and thought it would be good if I could rename tabs with the data I load.

This can be done through VBA, check: MrExcel.com