Rob: thanks for the idea. I already maintain a list of
sheets so comparing current sheets with the list each time
any sheet is activated should work. That might work for
the rename problem too, I will wrok on that ...
-----Original Message-----
You can capture Worksheet additions and deletions with
Workbook_SheetActivate (maintain a list of worksheets and
check for
differences)

Not sure how to capture a rename event though.

Rob


"MWE" wrote in
message
...
I wish to have VBA "know" each time a sheet is added,
renamed or deleted. The adding is easy using the
Workbook_NewSheet sub. But what about renaming or
deleting? I could restrict the user so that sheet adds,
renames and deletes are only done under VBA control,
but I
would rather let the user do things the way they want
and
capture significant events behind the scenes.

Thanks


.