Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet close event?
How do I know when a worksheet is closed?
Many thanks Has |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
before close event with condition | Excel Discussion (Misc queries) | |||
EXCEL close event? | Excel Programming | |||
Workbook Close Event | Excel Programming | |||
Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming | |||
After Close Event? | Excel Programming |