add a hyperlink to a control button

[stormcloudgathering]

I'm so embarrassed to have to ask these things, but hey, I guess that's what the site's for!
I would like to add a control button to a spreadsheet which, when clicked takes the user to another sheet within the workbook.
Please would someone be able to help me?
many thanks
lynne

 

[SkipVought]

Hi,

Turn on your macro recorder and record doing what you want to do.

Observe your code.

Clean it up if need be.

Assign to the button

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[xlbo]

Hi Lynne. standard code construct is:

Sheets(Sheet Name).select

Simply add a button (from the Forms toolbar would probably be best for you), add your sub-routine to a module:

Sub NameTheSubroutine()
Sheets(Sheet Name).select
End Sub

right click on button and assign the macro to the button

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question