View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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