Hide & Unhide Sheets Using Image or Icon

[KingOfKings31]

Hi there. I've recently created a workbook for work that contains a dashboard along with other sheets that contain the data that feeds the dashboard. On the dashboard itself, I want to use an icon/image as a button to unhide a specific sheet in the workbook that's hidden, but also have the sheet re-hide itself when the page is clicked off of or when a icon/image button on that page is clicked. I know VBA code will be needed, but I just dont know the code to make this happen. Any and all help will be appreciated!

 

[Fluff]

@KingOfKings31
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Please see rule 12 here: Forum Rules.
I have merged both threads

 

[KingOfKings31]

I keep receiving a runtime error that says Method 'GoTo' of Object'_Aplication' failed

 

[My Aswer Is This]

You need to show us the code your using.

 

[KingOfKings31]

Here is the code:

Sub Alarm_Unhide()
Sheets("Alarm_Descriptions").Visible = True
Application.GoTo Sheets("Alarm_Descriptions").Range("A1")
End Sub

 

[My Aswer Is This]

The script works for me.

I just tested it. Are you sure your sheet names are exactly as shown in the script?
What version of Excel are you using?
Are you using a PC or a Apple Computer.

 

[KingOfKings31]

I'm on a PC using Office 365 Excel. And yes I am sure of the name because when I run the code, the sheet unhides and it does go to the page, but it also gives me the Run-time error '1004' code.

 

[Fluff]

Is the sheet protected?

 

[My Aswer Is This]

I have no answer why it's not working for you.
Do you have some other code in the sheet your trying to unhide.

 

[KingOfKings31]

The sheet(s) are protected. But I was able to adjust the code using "ThisWorkbook.Sheets instead of Application.GoTo function and that resolved the issue.

 

[My Aswer Is This]

Show me the full code you now say works for you.