Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open and Hide a workbook
How can I open Workbook 1 and have Workbook 2 automatically open and be
hidden? Then, when Workbook 1 is closed, will Workbook 2 close also? Thank you in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open and Hide a workbook
Paste following code into ThisWorkbook's code:
Private Sub Workbook_Open() Dim oWB As Workbook Set oWB = Workbooks.Open(Me.Path & "\Workbook2.xls") oWB.Windows(1).Visible = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Workbooks("Workbook2.xls").Close False End Sub HTH -- AP "MBum" a écrit dans le message de news: ... How can I open Workbook 1 and have Workbook 2 automatically open and be hidden? Then, when Workbook 1 is closed, will Workbook 2 close also? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
how do i hide columns in excel so no one can open them. | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
How do I hide rows in excell 2003, and see the + sign to open? | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |