LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HL HL is offline
external usenet poster
 
Posts: 8
Default Hiding worksheets based on user selection

Hello,

I have created an Excell spreadsheet with 5 sheets. The tabs are called:
Introduction (sheet 1), Process A(sheet 2), Process B(sheet3), Process
C(sheet 4), & Process D (sheet 5).

For the Introduction sheet, I have four questions that can be answered Yes
or No. By the way, I am using a drop-down menu for the Yes/No response.

How can I hide specific sheets if the user answers yes to a question? For
example: If the user answer yes to the first question, then I would like to
hide sheets 3-5?

Thanks.
 
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
macro that brings user to cell based on "yes/no" response lennyx2 Excel Discussion (Misc queries) 2 February 9th 05 02:47 PM
Hiding columns based on user/password jmatchus Excel Worksheet Functions 0 January 17th 05 06:49 PM
Hiding Worksheets Jo Davis Setting up and Configuration of Excel 4 January 13th 05 11:15 PM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM
Hiding rows based on date Steve Excel Worksheet Functions 2 November 1st 04 02:30 PM


All times are GMT +1. The time now is 05:53 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"