Hiding Workbook with other workbook open

[06nenglish]

Hi All,

What I basically have is 2 workbooks the first one opens when the user selects to open it and the second one opens when the first workbook is open (In workbook open).

I would like to hide up the 2nd workbook - but the first workbook is constantly referencing the second workbook for information.

Does anyone know how would be best to do this?

Thanks in Advance

[vbfbryce]

create a workbook object, then hide it. you can still "get at it" when hidden, like so:

Dim wb2 As Workbook     

Private Sub Workbook_Open()   'opening "workbook1"
    Dim myDir As String
    Dim myFile As String
    
    myDir = ActiveWorkbook.Path
    myFile = myDir & "\wb2.xlsx"
    Set wb2 = Workbooks.Open(myFile)
    wb2.Windows(1).Visible = False
    MsgBox wb2.Worksheets(1).Range("a1").Value  'to show you can access the hidden workbook object
End Sub

[06nenglish]

create a workbook object, then hide it. you can still "get at it" when hidden, like so:

Dim wb2 As Workbook     

Private Sub Workbook_Open()   'opening "workbook1"
    Dim myDir As String
    Dim myFile As String
    
    myDir = ActiveWorkbook.Path
    myFile = myDir & "\wb2.xlsx"
    Set wb2 = Workbooks.Open(myFile)
    wb2.Windows(1).Visible = False
    MsgBox wb2.Worksheets(1).Range("a1").Value  'to show you can access the hidden workbook object
End Sub

Thanks it worked great!