Return to sheet you were on before you ran macro

[BRISBANEBOB]

I have a hyperlink that takes the user to a help sheet. The hyperlink can be activated from a number of difference sheets. Once the user reaches the instruciton sheet they need to be able to scroll around to read it fully but they will not need to enter any data or activate any cells. How can I get it so once they have read the instrucditons they can return to the sheet they started from?

[patel45]

do you use hyperlinks or macros ?

[HaHoBe]

Hi, patel45,

I have a hyperlink that takes the user to a help sheet.

Does that answer your question?

@BRISBANEBOB:
I only know of VBA to take care of that issue. Have a try with this which you would need to copy into ThisWorkbook:

Please Login or Register  to view this content.

You would need to adapt the name of the instructions sheet accordingly.

Ciao,
Holger

[BRISBANEBOB]

Hi
thanks for your reponse. I've used hyperlinks but happy to use code if necessary

[BRISBANEBOB]

Hi Holger

I'm lost! Which are the shhet names i need to change and how is the code triggered once the user has finished reading the instructions?

[HaHoBe]

Hi, BRISBANEBOB,

the sheet name is the Constant being used in both procedures (here: Instruction) which you would need to adjust to your needs.

I placed annother hyperlink into the sheet Instruction which after being pressed gets you back into the sheet you went into the sheet Instruction. I slightly altered the code for FollowHyperlink:

Please Login or Register  to view this content.

Ciao,
Holger

[Andy Pope]

You can add a shape/forms buttons to the help sheet with the following macro assigned.

Please Login or Register  to view this content.