Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JoeleneW
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Jim Cone
 
Posts: n/a
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink to an image in other worksheet, displaying entire image. twilliams Excel Worksheet Functions 0 February 7th 06 10:02 PM
hyperlink to another worksheet billy boy Excel Worksheet Functions 2 November 25th 05 01:10 PM
Can specific cells on a worksheet be hidden & password protected? Ann Excel Worksheet Functions 6 July 5th 05 09:08 PM
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"