Hello Mark,

Yes you can do this. Here is macro to rename the Active Worksheet to
whatever the Active Cell contains. Add A VBA module to your Workbook
and copy the macro code into it. You can then select the macro from the
Macro List (press the ALT key and then press F8 to bring it up) and run
it without using a control.

Macro Code:

Sub RenameSheet)
ActiveSheet.Name = ActiveCell.Value
End Sub

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503031