Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel worksheets (https://www.askmehelpdesk.com/showthread.php?t=727498)

  • Jan 11, 2013, 06:03 PM
    thoabailey
    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?
  • Jan 12, 2013, 03:30 PM
    JBeaucaire
    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?

  • All times are GMT -7. The time now is 04:18 PM.