View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default 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