Open Referenced Workbook

[pizzaboy]

I have an Excel Project (Videos.xlsm - project name: videos) which references another Workbook (Series.xlsm - project name: Series). What I would like to do, is open the workbook if its not already open.

Is there a way to do it without manually referencing paths or filenames? I already have a direct reference to it...

Can I do something like this:

(Series.ThisWorkbook)

Public Sub Open()
    If MeIsNotOpen Then OpenMe()
End Sub


(Videos.ThisWorkbook)

Private Sub Workbook_Open()
    Call Series.Open()
End Sub

Any help would be greatly appreciated.

Thanks

 

[pizzaboy]

Think I was having some issues with the Trust Center permissions.

Added directly to the Add-Ins via Excel Options. Re-referenced Series.xlsm, and it opened automatically when Videos.xlsm was opened!