Create button that opens up other workbook

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