Shortcut to worksheet

[selsley]

I'm trying to create a shortcut on the desktop to a particula
Worksheet. If I create a shortcut on the desktop to the Workbook an
right-click what do I type in "Target:"

Many thanks

Selsle

 

[Bob Phillips]

Selsley,

You can't. You can do a shortcut to a workbook, but not sheet.

What you could do is add a macro to the workbook that goes to your
worksheet, something like

Sub Auto_Open()
Worksheets("Sheet2").Activate
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[selsley]

Many thanks for that Bob. I'm just a beginner! hope the weather at Pool
is fine today (not in Cheltenham)

Stev

 

[Bob Phillips]

No, it is damp and miserable.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[selsley]

Bob

Yes it works perfectly! Now to try out more macros.

Thanks again

Stev