Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event Procedure - Pick List Choice Unhides Worksheet
Hello,
I have a "Master Worksheet" in which there is a cell that allows the user to choose different geographic regions from a drop list (using data validation). In addition, there are 10 hidden worksheets I will call "supporting" (one for each geographic region). I would like to create an event procedure that unhides the supporting worksheet associated with the geographic region chosen from the Master Worksheet, and hides (or keeps hidden) the other other supporting worksheets. More succinctly, only show the Master worksheet and the associated supporting worksheet as dictated by that chosen in the Master...... Thanks a lot in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Procedure with a worksheet change event | Excel Worksheet Functions | |||
Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
Event Procedure - Data Validation List | Excel Programming | |||
Calculate Value of Cell From Pick List Choice | Excel Discussion (Misc queries) | |||
Using VBA to track changes in a worksheet - help! Event procedure?? | Excel Programming |