Mike,

There is no event for a worksheet name change.
You could use the Activate and Deactivate sheet events
to check the sheet name.
However that is not a real time catch for a rename.

What you can do is set an object reference to the sheet
and use that to access the sheet.
The user can change the name and it won't matter...

Dim objSheet as Excel.Worksheet

Set objSheet = Worksheets("originalname")
-or-
Set objSheet = ActiveSheet
-or-
Set objSheet = Worksheets(1)
-or-
Set objSheet = Workbooks("SomeOther").Worksheets("sludge")

Use it like this...
objSheet.Range("B5").Value = "Oats"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




"Mike Archer"
wrote in message
Hello - is there an event or a good way to invoke code when a sheet is renamed?
--
Thanks,
Mike