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