How do i make a button in a spreadsheet to open another spreadsheet,
without using hyperlinks?

Aiden

Tools, Macro, Record New Macro then open the file you need
and stop the recording.

Choose View Toolsbars, Forms and draw a button on the
worksheet. Righ-click the button and choose Format and
make sure that it doesn't print.

Right_click the button again and assign the macro that you
recorded.

Regards
Peter
-----Original Message-----
How do i make a button in a spreadsheet to open another
spreadsheet,
without using hyperlinks?
.

Hi,
Add a module to your workbook and paste the code :

Public Sub openFile()
Dim strFileName As String
strFileName = Application.GetOpenFilename
Workbooks.Open strFileName
End Sub

and then add a button on the worksheet with Forms t.bar or add a custo
button to a t.bar andd assign the macro to this button.

that's all you have to d

--
Message posted from http://www.ExcelForum.com