Naming a sheet

[Navin Agrawal]

Hi:

How can I name the sheets in a file with the content of a particular cell on every sheet.

For example, cell A2 of every sheet contains the name of a person in the team. How can I automatically name each sheet with the particular name in cell A2?

Sheet 1 has John in cell A2
Sheet 2 has Peter in cell A2
Sheet 3 has Mark in cell A2

and so on....

Sheet 1 should automatically get named John, Sheet 2 Peter, Sheet 3 Mark and so on.... such that as I keep adding sheets in the file, the new sheet should automatically get named with the name contained in cell A2...

Thanks & Regards,

[arlu1201]

Try this

Please Login or Register  to view this content.

Copy the Excel VBA code that you want to use
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

When you click on "save" on your file, the sheetnames will be changed accordingly.

[Navin Agrawal]

Thanks a lot.... appreciate your help....