Windows XP Command Button on a Worksheet

[Randhart]

Hi there

I'm no programmer and really need some help. I am trying to place a command button on a excel spreadsheet that will take you to another worksheet within the same workbook when you click on it.

I really hope someone out there can help me!
Regards
R

 

[LadyReader]

button

Do you know how to add a button? If not do,
View
Toolbars
Control Toolbox
Click on Command Buton icon and put the button where you want it
Right click, click on Properties, change name and text. I changed my button name to "PrintCommandButton" and the text to "Print Charts".

Then code:

'Step 1:
Private Sub PrintCommandButton_Click()
PrintCharts
End Sub

'Step2:
Public Sub PrintCharts()
'Navigate to correct spreadsheet:
Sheets("DesiredSheetName").Select

'Whatever you want to do:
...
End Sub

 

[Randhart]

Thanks for your help LadyReader