Data Selection Page Links
 

I have seen excel projects that kind of look like webpages, meaning you
open a worksheet and the only thing you see on it is 2 or 3 buttons and
no other worksheet tabs, one button might say "Income" the other says
"Expenses" and the third says "Calculations". When you click on one of
the buttons it opens up another worksheet that may give you 2 or 3 more
choices like "Monthly", "Quarterly", and "Yearly" again with no other
worksheet tabs. Then once you click on one of those buttonsyou will
get all of the worksheets associated with that selection.

My question is how is this done, cuase I want to do it?


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=469051

Data Selection Page Links
 

can anyone help on this?


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=469051

Data Selection Page Links
 

It's done by:

Adding the navigation buttons to the worksheets; be sure to include
buttons on the data worksheets to go back to the "menu" sheets...

Set properties to show scroll bars, sheet tabs, etc. using the Tools
Options menu...

Create macros assigned to the buttons that navigate to their assigned
function worksheet(s) & change above properties (if needed)...

Hide the worksheets you don't want shown (use Format Worksheet Hide
menu option) until a naigation button is pressed...

To make the "menu" sheets look like a web page, you hide all unused
columns & rows that aren't covered by the buttons on the sheet, then
you use the fill color on the remaining visible cells that matches the
background color that shows after hiding the columns/rows.

You can also create event macros assigned to the workbook that sets the
"baseline" state of the workbook (i.e., the 'main' sheet is always
displayed when the workbook is opened/closed).

Hope this helps,
theDude


--
theDude
------------------------------------------------------------------------
theDude's Profile: http://www.excelforum.com/member.php...o&userid=16550
View this thread: http://www.excelforum.com/showthread...hreadid=469051

Data Selection Page Links
 

Thank you. I have started on this but you gave me some tips that I had
not thought about.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=469051