Ask Experts Questions for FREE Help !
Ask
    thoabailey's Avatar
    thoabailey Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jan 11, 2013, 06:03 PM
    Excel worksheets
    I have 12 Excel worksheets in a single document. The first worksheet is a general survey with yes/no questions and hyperlinks to the other worksheets only if applicable. I worry that 12 worksheets may appear overwhelming to the user. Is it possible to hide the other worksheets until the hyperlink is clicked on (at which point the worksheet will open)? So in effect, the user will only have worksheets that are applicable to his situation, while the other worksheets still remain hidden?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jan 12, 2013, 03:30 PM
    That would require a non-trivial amount of VBA programming to accomplish, and anyone using the workbook would have to enable macros. Not everyone is comfortable with that.

    Do you have any experience with VBA?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel linking worksheets [ 1 Answers ]

Can we link two or more worksheets in one excel file?

Excel If function using 2 worksheets [ 4 Answers ]

I am using Excel 2007. I have created a spreadsheet1 with a list of names and dates. The names and dates can be repeated. I have another spreadsheet 2 with names and formulas. Here the names are not repeated. The formulas adjust the dates for aging purposes. If the name on Spreadsheet 1 equals...

Using one Excel list table in multiple worksheets [ 2 Answers ]

I have a workbook containing 13 worksheets. Sheet 13 contains two list tables. I need to link sheets 1 through 12 to the list tables in sheet 13 so that only one set of lists has to be updated when changes occur. Please help me...

Excel 2003 linking worksheets [ 6 Answers ]

Hi, I am not sure if I am in the right area but I need to ask about excel 2003. I have a simple question which I do believe there is an answer but I have tried various options to no avail. Does anyone know where I can ask expert advise about excel 2003. Many thanks for any advise given.:)

Excel Worksheets [ 1 Answers ]

I have several worksheets in an Excel spreadsheet. Is there a way that I can print a list of the names of each of the worksheets in the spreadsheet?

View more questions Search