I don't see a role for a hyperlink.

Private Sub CommandButton1_Click()
Worksheets("Sheet3").Activate
End Sub

--
Regards,
Tom Ogilvy


"jim9912" wrote:

I need a macro to jump to display another worksheet within the same
workbook when a button is pushed. I tried to use a control button and
then insert a hyperlink, but the hyperlink only works while in design
mode. What I want to do is display the button on one worksheet and
when it is pressed jump to another worksheet. I know this must be
something simple that I am just missing. help!?