Worksheet close event?
 

How do I know when a worksheet is closed?
Many thanks

Has

Worksheet close event?
 

Has

I think you'll need to give us more info. Worksheets don't have close
events, workbooks do, what exactly are you looking to do or the problem you
are encountering?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"has ex" wrote in message
...
How do I know when a worksheet is closed?
Many thanks

Has

Worksheet close event?
 

Thanks for the reply,
I have an out of proc application (automating Excel with C++ client)
that holds references to many ranges. If user deletes one of the worksheets
that I have a reference, then I need to clear my pointers. I am able to do
this if the user deletes the workbook, because I get an event on the close,
but not if he deletes a single worksheet.
Many thanks

Has

"Nick Hodge" wrote in message
...
Has

I think you'll need to give us more info. Worksheets don't have close
events, workbooks do, what exactly are you looking to do or the problem
you are encountering?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"has ex" wrote in message
...
How do I know when a worksheet is closed?
Many thanks

Has

Worksheet close event?
 

Has

C++ is beyond me, can you not check the existence of the object and check
for Nothing as in VB or trap the error and act?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"has ex" wrote in message
...
Thanks for the reply,
I have an out of proc application (automating Excel with C++ client)
that holds references to many ranges. If user deletes one of the
worksheets that I have a reference, then I need to clear my pointers. I am
able to do this if the user deletes the workbook, because I get an event
on the close, but not if he deletes a single worksheet.
Many thanks

Has

"Nick Hodge" wrote in message
...
Has

I think you'll need to give us more info. Worksheets don't have close
events, workbooks do, what exactly are you looking to do or the problem
you are encountering?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"has ex" wrote in message
...
How do I know when a worksheet is closed?
Many thanks

Has

Worksheet close event?
 

Unfortunately, I need to inform the user at that time.
Thanks.

Has

"Nick Hodge" wrote in message
...
Has

C++ is beyond me, can you not check the existence of the object and check
for Nothing as in VB or trap the error and act?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"has ex" wrote in message
...
Thanks for the reply,
I have an out of proc application (automating Excel with C++ client)
that holds references to many ranges. If user deletes one of the
worksheets that I have a reference, then I need to clear my pointers. I
am able to do this if the user deletes the workbook, because I get an
event on the close, but not if he deletes a single worksheet.
Many thanks

Has

"Nick Hodge" wrote in message
...
Has

I think you'll need to give us more info. Worksheets don't have close
events, workbooks do, what exactly are you looking to do or the problem
you are encountering?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"has ex" wrote in message
...
How do I know when a worksheet is closed?
Many thanks

Has