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Ä
|