opening buttons
 

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

opening buttons
 

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?
.

opening buttons
 

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