View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Start macro by Command Button?

drag a commandbutton to the worksheet.

double click on it

Private Sub Commandbutton1_click()
Workbooks.Open "C:\Myfolder\MyFile.xls"
End Sub

return to Excel

take the sheet out of design mode by clicking on the icon in the upper left
corner of the Control Toolbox Toolbar (which should appear depressed since
the sheet is in design mode)

--
Regards,
Tom Ogilvy


"KentÄ" wrote in message
...
Hi
I would like to start a macro which open another excelfile, by clicking a
commandbutton.
Thanks for your help
KentÄ