Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I'm trying to hide/show tabs based upon a and end user's inputs. For example, let's say my worksheet is all about fruits and I have four tabs. An Inputs sheet, which asks for general information on apples, oranges, tomatoes (yes, they're a fruit) and then I have a tab for each one of these fruits. Now, let's say a farmer doesn't have Oranges. Hiding it from the Inputs sheet is easy, I simply have grouped that section and the farmer needs to click on the "minus" sign at the left of the sheet. But what about the actual Oranges tab? As you can guess, farmers don't exactly get excel and I'm afraid they'll get confused that the Oranges tab still exists even though they hid them on the Inputs tab. Can someone help me hide apples from oranges? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table: How do I hide calculated items that result in zero? | Charts and Charting in Excel | |||
Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
How can I hide a range of columns without hiding charts there? | Charts and Charting in Excel | |||
How do I automatically hide rows | Excel Discussion (Misc queries) | |||
Conditional Hide function for Excel | Excel Worksheet Functions |