Need button or menu to load a file

[Spiff]

I would like to create a button or menu item that would load a specific Excel
file. How do I do this?

Henry

 

[Dave Peterson]

Try Insert|Hyperlink

It may be the easiest way.

I would like to create a button or menu item that would load a specific Excel
file. How do I do this?

Henry

 

[Spiff]

Dave,

Thanks, that will work inside a document but I meant to say that I wanted to
add a button to Excel's toolbar that would launch the file. You used to be
able to do this with Office's shortcut bar, but that's gone now.

Henry Falk

 

[Dave Peterson]

If you want to use a button that opens a workbook, then you could record a macro
when you open that workbook manually.

Then customize the toolbar
(Tools|Customize)
and assign your macro to that custom button.

 

[Spiff]

Dave,

Thanks, that worked perfectly!

Henry

If you want to use a button that opens a workbook, then you could record a macro
when you open that workbook manually.

Then customize the toolbar
(Tools|Customize)
and assign your macro to that custom button.