Rename Sheet Event
 

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

Thanks in advance

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

Rename Sheet Event
 

You've gotten other replies to your other post.

kt wrote:

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

Thanks in advance

--

Dave Peterson

Rename Sheet Event
 

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

"Peter T" <peter_t@discussions wrote in message
...
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

Rename Sheet Event
 

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

"Dave Peterson" wrote:

You've gotten other replies to your other post.

kt wrote:

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

Thanks in advance

--

Dave Peterson