Floating Inserted Shape with hyperlink

[writyl0730]

I'm looking to have an inserted shape (button) act as a hyperlink to a main excel tab. Ultimately a hyperlink to the first tab.

Since the tabs are quite busy, I don't want to cover up, add a row or column to the tab, I'm looking to have a shape act as a button but scroll with the user. I'm looking to have it on the bottom right hand side of the tab.

I've looked but coming up short.

Any suggestions?

Thanks!

 

[My Aswer Is This]

And you want to see this shape on all of your sheets?
And when you click on this shape you want to be taken back to Master sheet is that correct?

 

[My Aswer Is This]

If your wanting a easy way to always get back to sheet(1)
Try using this script.

Anytime you double click on any empty cell in any sheet.
You will be taken back to Sheet(1) Range("A1")

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on any sheet tab

Select View Code from the pop-up context menu​

Double click on ThisWorkbook

Paste this code in the VBA edit window.

Now any time you double click on any empty cell on any sheet you will be taken back to Sheet(1) Range("A1")

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
'Modified 6/19/18 5:05 PM EDT
If Target.Value = "" Then
Cancel = True
Application.Goto Sheets(1).Range("A1"), True
End If
End Sub

 

[writyl0730]

And you want to see this shape on all of your sheets?
And when you click on this shape you want to be taken back to Master sheet is that correct?

To start I wanted to have it in one sheet and try to dissect it and learn how to do it on the others

I'll try the below as well to see if that will work

 

[writyl0730]

If your wanting a easy way to always get back to sheet(1)
Try using this script.

Anytime you double click on any empty cell in any sheet.
You will be taken back to Sheet(1) Range("A1")



This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on any sheet tab

Select View Code from the pop-up context menu​

Double click on ThisWorkbook

Paste this code in the VBA edit window.

Now any time you double click on any empty cell on any sheet you will be taken back to Sheet(1) Range("A1")

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
'Modified 6/19/18 5:05 PM EDT
If Target.Value = "" Then
Cancel = True
Application.Goto Sheets(1).Range("A1"), True
End If
End Sub

Getting back to this finally - took a break from this project and now back
This isn't working for me. I'm viewing code for a specific worksheet (tab) inputting the above and nothing is happening when I double click an empty cell - thank you!

 

[My Aswer Is This]

I just tested this script again.
Did you follow these instructions:

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on any sheet tab
Select View Code from the pop-up context menu
Double click on ThisWorkbook
​

And paste in this code.

 

[writyl0730]

I just tested this script again.
Did you follow these instructions:

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on any sheet tab
Select View Code from the pop-up context menu
Double click on ThisWorkbook
​

And paste in this code.

got it - apologies i messed a few things up as i was trying this out...got it though!!!

thank you!

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

got it - apologies i messed a few things up as i was trying this out...got it though!!!

thank you!