Worksheet shortcuts.

[trevolly]

Hi all.

I recently made a Daily log for work and part of this was a Hanover Sheet that could be filled in and with the help of some v clever members of this site, have a vba code in the worksheet that when actioned copies the Handover worksheet in to the next shifts Daily Log. This enables the Handover sheet to be saved from shift to shift, allowing vital info for each shift to be ready for the day / night.

This works well apart from……. On the Handover Sheet I have made some “jump to” shortcuts by putting a button in and then recording a macro allowing the user to jump to a certain part of the Handover sheet.

Macro consists of …..
Sub Marshalling()
‘
‘Marshalling Macro
‘
Range (“A106”). Select
End Sub

This works apart from when the Handover sheet is copied to the next shift. Then when these “jump to” shortcuts are pressed then the original Daily log workbook opens in the background (I suppose because that’s where the original Handover sheet and the macro shortcuts were recorded).

Is there any way to make one of these “jump to “ shortcuts / buttons on the Handover sheet without it referencing the original workbook and opening it?

 

[Fluff]

My pleasure.

 

[My Aswer Is This]

Ahhh that seems easier @Fluff. Thank you - why is excel so confusing!!

You will learn with Excel there is always 10 different ways to do every thing.
You can run a entire script by double clicking a cell. But in your case a Hyperlink works well.