Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a referenced workbook
Hi all,
I have several workbooks, all of which refer to a single Excel file ("referenced file") which contains common subroutines. I am considering the possibility of closing the referenced file when a workbook is closed. I am considering using the Workbook_BeforeClose event procedure, but the problem is, at the time of closing a workbook, it still refers to that referenced workbook and Excel just doesn't allow me to close it. Any workarounds? Thanks for your advice in advance. Frederick Chow |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indexing Sheets in Referenced Workbook within formula | Excel Worksheet Functions | |||
Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
Workbooks referenced by a deleted workbook | Excel Programming | |||
Workbook referenced by a deleted workbook | Excel Programming | |||
closing excel after closing a workbook | Excel Programming |