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