Use the Open event of a workbook. Like in the following example from Visual Basic for Excel help:
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub
You want to open another workbook, I understand. Help says this is the code to do so:
Workbooks.Open "ANALYSIS.XLS"
It's a method of the workbooks object.
You'll need a msgbox and an if, but that won't be very difficult.
Hope this helps.
Kees
Hi there,
I was thinking if it was possible to prompt the user if he/she would like to open another workbook when he opens a workbook. This could preferably be by means of a message box.
If it is not possbile, could i create a button and insert the relevant macro commands so that when the user clicks on that button on the main page of one workbook, it will open another workbook.
Hope you can help!
Thanks=)

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic