₦airaland Forum

Can any body help me on how to programm Excel to use Command button to open different workbooks and or sheets

Thanks

sbucareer:

Open your spread sheet and make forms visible. i.e. View - Toolbars - Forms.

Click the button control and position to a desired location on the Sheet interested. To connect it to another sheet on event click. Go to Tools - Macro - Visual Basic Editor and type


Private Sub CommandButton1_Click()
Windows("Filename.xls".Activate
Sheets("Sheet2".Select
End Sub



If the work sheet is in anther file in your physical directory, use this code snipets


Sub Commandbutton1_click()
Dim WbookCheck As Workbook

On Error Resume Next
Set WbookCheck = Workbooks("Filename.xls"
On Error Goto 0

If WbookCheck Is Nothing Then 'Closed
Workbooks.Open "C:\Filename.xls"
ElseIf Application. ActiveWorkbook. Name = WbookCheck.Name Then
WbookCheck.Close SaveChanges:=True
Else
WbookCheck.Activate
End If
End Sub

@sbucareer
You are so dynamic. I admire your wealth of knowlege and experience.

sbucareer thank you very much for this assistance I have not tried because I am seriously busy in the office. As soon as I tried it I will inform you.
Thanks.