Create button that opens up other workbook

Have you tried recording a macro yourself while opening the file of choice?
Give it a try. The macro Recorder is your friend.

After you create the macro, activate the Forms Toolbox, select the Command Button control and place a button on the worksheet (click and drag to create and size the button), the right click the button, choose Assign Macro and pick the appropriate macro. You may also edit the text on the button.

If you have trouble post back

Hi there,

Yes I did try that but it didn't seem to work. I would just use a button as a hyperlink but as I have other buttons that activate macros this causes problems. Once you click the link it also activates/deactivates design mode which you then have to access before the macro buttons work again, defeating the potential time saving ability the H-link is supposed to offer

Thanks for you help on the matter though. If you can think of anything else please let me know.

Al

Try adapting this. It's very basic, no error checks/handling, checking if file or folder exists, etc. - don't have time to do more, but you can search.

Sub X()

    ChDrive "C" 'change per your requirements
    ChDir "C:\Temp"
    Workbooks.Open ("MyWorkbook.xls")

End Sub