Thread
:
Worksheet close event?
View Single Post
#
5
Posted to microsoft.public.excel.programming
has ex
external usenet poster
Posts: 4
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
Reply With Quote
has ex
View Public Profile
Find all posts by has ex