A Aidan Jan 23, 2004 #1 How do i make a button in a spreadsheet to open another spreadsheet, without using hyperlinks?
P Peter aTHERTON Jan 23, 2004 #2 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
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
T tolgag Jan 23, 2004 #3 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
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
