![]() |
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 |
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