| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking for Open Workbook
I've put a button on a spreadsheet that opens another workbook, works
fine if the other workbook isn't already open. What I need to do, is to modify this so that it checks to see if this workbook is already open, and if it is pop-up a message box saying the workbook is already open, otherwise it can just go ahead and open the closed workbook... TIA for any suggestions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking for Duplicates within a Workbook | Excel Worksheet Functions | |||
| RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
| checking if workbook is open before accessing | Excel Programming | |||
| VBA Excel Checking whether an XL file is already open elsewhere | Excel Programming | |||
| Using wildcard for checking whether files are open | Excel Programming | |||
Threaded Mode
