Rename Sheet Event
If cell(so) on the renamed sheet are referred to in other sheet(so),
Worksheet_Calculate followed by Workbook_Sheet events occur for each "other"
sheet in question. Some formulas may also directly refer to the sheet name
on the renamed sheet.
Do you have any Duff's. If so, put a break on each, rename the sheet, step
through code and look for the unexpected.
Regards,
Peter T
"kt" wrote in message
...
When we rename a sheet Excel crashes. What event is triggered when a sheet
is renamed.
Thanks in advance
|