ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding a command button to open another spreadsheet (https://www.excelbanter.com/excel-programming/399489-adding-command-button-open-another-spreadsheet.html)

joel

Adding a command button to open another spreadsheet
 
Hi

CAn anyone tell me the VBA for opening another spreadsheet if I place a
command button on my Spreadsheet so I can create an index page

Thanks Joel
--
N/A

JW[_2_]

Adding a command button to open another spreadsheet
 
Sub likeThis()
Workbooks.Open "C:\Book18.xls"
End Sub

Or, you can simply create hyperlinks to your workbooks instead of a
button for each one.

Joel wrote:
Hi

CAn anyone tell me the VBA for opening another spreadsheet if I place a
command button on my Spreadsheet so I can create an index page

Thanks Joel
--
N/A




All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com