ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Hyperlink to hidden worksheet (https://www.excelbanter.com/new-users-excel/82771-hyperlink-hidden-worksheet.html)

JoeleneW

Hyperlink to hidden worksheet
 
I have a spreadsheet with many tabs, and am trying to keep things simple for
the end users.
Is there a way to hyperlink to or create a button w/macro that goes to a
hidden worksheet?

Jim Cone

Hyperlink to hidden worksheet
 
A hyperlink will not work on a hidden sheet.
This code attached to a button shows the sheet "Salaries"...
'--
Sub LetsSeeIt()
Worksheets("Salaries").Visible = True
End Sub
'--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"JoeleneW"
wrote in message...
I have a spreadsheet with many tabs, and am trying to keep things simple for
the end users.
Is there a way to hyperlink to or create a button w/macro that goes to a
hidden worksheet?


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com