Insert a Active Button to all sheets with the same funcion

[MoldyBread]

Hi everybody,

after I got so great support least time, I hope you can support me in this one as well.

I have an excel file with 150 sheets. My first sheet is an overview sheet where from where I can jump to each sheet.
Now I want to insert a similar way backwards. On each of the 150 sheets should be a Button and when I click it, I jump to the "Overview" sheet.

My Idea was to use an Active X Button and use this code to jump:

Please Login or Register  to view this content.

But unfortunately I can't just copy this button by copy past to all sheets because the code will be lost.

Is there a smart way to this automatically?

The box should have the same position, colour and function as in the example attached.
Caption: Jump to Overview
Backcolor: &H0000FF00&
Left: 890
Top: 185

Thanks so much for your ideas.

[nigelog]

Can you not just open the workbook on the Overview worksheet

add back in the navigate buttons to the mini menubar and use the navigate buttons

[MoldyBread]

Unfortunatley I dont understand what you mean.
The challange is also how to create on each sheet the same box at the same place?

[nigelog]

Add a form button to sheet "Overview"

Please Login or Register  to view this content.

[MrMyagiii]

Just use your original code

Please Login or Register  to view this content.

and add this to a hotkey? so for example CTRL+SHIFT+1 brings you back to overview

OR use the above mentioned solution, also works.