Hello,

How can i trap the rename event of an excel sheet?
Is it possible to get the renamed sheet name as soon as it'd changed?

thanks and rgds

There is no "rename event" in XL. If you have the Cell("filename")
function on the sheet, renaming the sheet will fire the Calculate event,
where you can check the name against a static or global variable.


In article ,
"bmm" <newsgroup.com wrote:

Hello,

How can i trap the rename event of an excel sheet?
Is it possible to get the renamed sheet name as soon as it'd changed?

thanks and rgds

Just to add:
Believe
=Cell("filename")

Will return the name of the activesheet, so you might want to use

=Cell("filename",A1)

the second argument can be any cell reference (on the sheet).

--
Regards,
Tom Ogilvy


"JE McGimpsey" wrote in message
...
There is no "rename event" in XL. If you have the Cell("filename")
function on the sheet, renaming the sheet will fire the Calculate event,
where you can check the name against a static or global variable.


In article ,
"bmm" <newsgroup.com wrote:

Hello,

How can i trap the rename event of an excel sheet?
Is it possible to get the renamed sheet name as soon as it'd changed?

thanks and rgds

Tom -

Do you see any difference in terms of firing a Worksheet_Calculate or
Workbook_SheetCalculate event when a sheet in the workbook is renamed? I
don't with MacXL.

I was just thinking of an event trigger. If the filename is to be used,
your addition is obviously the correct one.


In article ,
"Tom Ogilvy" wrote:

Just to add:
Believe
=Cell("filename")

Will return the name of the activesheet, so you might want to use

=Cell("filename",A1)

the second argument can be any cell reference (on the sheet).

If your only intent in using cell was to trigger a calculate event, then I
guess it doesn't make any difference what value it returns.

--
Regards,
Tom Ogilvy



"JE McGimpsey" wrote in message
...
Tom -

Do you see any difference in terms of firing a Worksheet_Calculate or
Workbook_SheetCalculate event when a sheet in the workbook is renamed? I
don't with MacXL.

I was just thinking of an event trigger. If the filename is to be used,
your addition is obviously the correct one.


In article ,
"Tom Ogilvy" wrote:

Just to add:
Believe
=Cell("filename")

Will return the name of the activesheet, so you might want to use

=Cell("filename",A1)

the second argument can be any cell reference (on the sheet).