User Conditional View

[Guest]

Is there a way to create conditional workbook and worksheet views based on
the value of a particular cell?

Below is what I'm trying to accomplish:

I'm building a master budget template with multiple worksheets and not all
departments will use all worksheets. So, on the main page of the workbook I
want to have users select a department from a drop down menu and based on
that selection I only want worksheets that pertain to that particular
department to be displayed and worksheets that don't pertain to the
department hidden. Additionally I want show/hide certain columns in some of
the worksheets based on department selection on the main page.

Unfortunately, I do not know visual basic at all.

Thanks for any help.

James

 

[jeff]

Hi,

Yes there are ways. You might do some searches on this
site for "hide" and read some responses. As long as
you're not too worried about security, you could
1) hide all sheets except a "logon" sheet,
2) the logon sheet could have a drop down with a list
of depts to be selected from.
3) based on the selection, you can open (unhide) specific
sheets and do the same further for colums/rows.

If you know nothing about VBA, I'd record a few simple]
steps and then go read the recorded macro. also just
look at some of the responses in this UG for macro
examples.

Finally, if you'll send me your email address, I'll be
happy to help you in my off hours.

Jeff
jreese51@REMOVESPAM_Bellsouth.net