Rename Sheet Event

[Guest]

When we rename a sheet Excel crashes. What event is triggered when a sheet
is renamed.

Thanks in advance

 

[Peter T]

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

 

[Dave Peterson]

You've gotten other replies to your other post.

When we rename a sheet Excel crashes. What event is triggered when a sheet
is renamed.

Thanks in advance

 

[Peter T]

typos, due to not preventing my spell checker to change things -

cell(so) . . . sheet(so), . . . "Do you have any Duff's" should read
cell(s) . . . sheet(s), . . "Do you have any UDF's"

Dave has pointed out the OP posted same to another group which also has
replies (I wouldn't have known). For readers of this ng, here's the link -

http://tinyurl.com/9lj6e

Regards,
Peter T

 

[Guest]

Thanks for the contributions. This pointed us in the right direction.