Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook on close
If you're talking about closing a specific Workbook then you could use
this Private Sub Workbook_BeforeClose(Cancel As Boolean) Workbooks.Open "C:\FileToOpen.xls" End Sub This VBA code would need to be placed in the "ThisWorkbook" part of the file that is being closed. C_Ascheman wrote: Is there a way to detect when the small x in the upper right corner of the worksheet is clicked on, and as it is closing to open a predifined worksheet up. We have a workbook containing 5 worksheets. A completely blank version of the workbook is stored on the server. If one of our employees is working on any of the worksheets with in that workbook, and clicks on the worksheet x is it possible to open the blank workbook as that old one is closing? C_Ascheman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open and Close another Workbook from VBA | Excel Programming | |||
Before close and workbook open! | Excel Programming | |||
How can I close only 1 workbook when I have many open? | Excel Discussion (Misc queries) | |||
Close Open Workbook | Excel Programming | |||
Close Open Workbook | Excel Programming |