I have three following worsheets:
welcomepage.xls
as~project~witoutpics1.xls
database~as212.xls
These files are located on my desktop.
In the welcom page i have a button which i want in a way that after i click on it two other worksheets opens.
The example below is the macro i recorded using key strokes however is is not working.
Anyone knows an alternative please help.
Sub ENTERTOMAINMENU_BUTTON()
'
' ENTERTOMAINMENU_BUTTON Macro
' Macro recorded 11/04/2002 by Radek Ilendo
'
'
Windows("As~project~witoutpics.xls").Activate
Range("G4").Select
Sheets("Main menu").Select
End Sub
welcomepage.xls
as~project~witoutpics1.xls
database~as212.xls
These files are located on my desktop.
In the welcom page i have a button which i want in a way that after i click on it two other worksheets opens.
The example below is the macro i recorded using key strokes however is is not working.
Anyone knows an alternative please help.
Sub ENTERTOMAINMENU_BUTTON()
'
' ENTERTOMAINMENU_BUTTON Macro
' Macro recorded 11/04/2002 by Radek Ilendo
'
'
Windows("As~project~witoutpics.xls").Activate
Range("G4").Select
Sheets("Main menu").Select
End Sub