| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
opening a window via VBA
Anyone know how to open a 2nd workbook in VB? I also need it to close when
the original workbook closes |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
opening a window via VBA
You can use the auto_close() function in VB to close automatically the
workbook when you close the parent once. When do you want to open the 2nd workbook ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
opening a window via VBA
i would like to open it when the parent opens
"preymond" wrote: You can use the auto_close() function in VB to close automatically the workbook when you close the parent once. When do you want to open the 2nd workbook ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
opening a window via VBA
Please try Workbook_Open() and Workbook_BeforeClose events....
If this post helps click Yes --------------- Jacob Skaria "Lost" wrote: i would like to open it when the parent opens "preymond" wrote: You can use the auto_close() function in VB to close automatically the workbook when you close the parent once. When do you want to open the 2nd workbook ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening files in new window | Excel Discussion (Misc queries) | |||
| Opening worksheet in new window | Excel Discussion (Misc queries) | |||
| Hyperlinks opening in a new window. | Setting up and Configuration of Excel | |||
| Workbooks opening in browser window | Excel Discussion (Misc queries) | |||
| Opening excel in a new window | Excel Discussion (Misc queries) | |||
Linear Mode
