LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Need to have an index sheet but all other sheets should be hidden

Hi, Am a novice in excel. What i am trying to do is crate a index sheet with
different logo/pictures for sheets in the workbook. And when i end up
clicking on the logo, it should open the worksheet that its linked to. But i
do not want a workbook with som many sheets visible when opened & it shoudl
have only the index sheet with all references.

I did try & insert a picture & was able to successfully insert hyperlink to
the pic, and when the pic is clicked it takes me to the reference sheet.

Problem: If i hide the reference sheet, the hyperlink does not work. Any
solution for this?
 
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
Hidden Rows blocking TAB INDEX Tweedy Excel Discussion (Misc queries) 0 November 19th 07 09:54 PM
How do i reveal hidden sheets surreyjed Excel Discussion (Misc queries) 3 September 4th 06 06:50 PM
I need my Hidden Rows to stay hidden when I print the sheet. Rosaliewoo Excel Discussion (Misc queries) 2 July 20th 06 07:51 PM
Hidden Sheets QUESTION-MARK Excel Worksheet Functions 4 May 19th 06 07:06 PM
Operating on hidden sheets Hari Prasadh Excel Discussion (Misc queries) 2 January 28th 05 08:33 AM


All times are GMT +1. The time now is 08:00 AM.

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

About Us

"It's about Microsoft Excel"