Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update when worksheet close/delete
Hi,
I have a date sturcture hold information about worksheet. I need to update this data structure when somebody close/delete worksheet. Thanks, Samir. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update when worksheet close/delete
Not sure I understand - what is the Date Structure? Do you mean close the
workbook or delete a worksheet or deactivate the worksheet, delete the worksheet? -- Regards, Nigel "Samir Idrees" <Samir wrote in message ... Hi, I have a date sturcture hold information about worksheet. I need to update this data structure when somebody close/delete worksheet. Thanks, Samir. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update when worksheet close/delete
Hi,
Actually I have different worksheet and I store each worksheet object in a list to find out which one is active e.g type A or type B. I need to update this list when worksheet is delete and remove the worksheet object from the list. Actually I need worksheet delete event with worksheet name etc. In that way I can search my worksheet object list and delete the deleted worksheet object. Thanks, Samir. "Nigel" wrote: Not sure I understand - what is the Date Structure? Do you mean close the workbook or delete a worksheet or deactivate the worksheet, delete the worksheet? -- Regards, Nigel "Samir Idrees" <Samir wrote in message ... Hi, I have a date sturcture hold information about worksheet. I need to update this data structure when somebody close/delete worksheet. Thanks, Samir. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open and Close a Workbook to Update Links | Excel Discussion (Misc queries) | |||
Send Email on Update/Close | Excel Programming | |||
Delete Insert Worksheet on Open/Reset on Close | Excel Programming | |||
automate open/update/close Excel | Excel Programming | |||
automate open/update/close Excel | Excel Programming |