Su

Step #1 Get the Back Button
View Toolbars Web

Step #2 make the table of links
In Z1 thru Z10 put:
[Book1]Sheet1!A1
[Book1]Sheet2!A1
[Book1]Sheet3!A1
[Book1]Sheet4!A1
[Book1]Sheet5!A1
[Book1]Sheet6!A1
[Book1]Sheet7!A1
[Book1]Sheet8!A1
[Book1]Sheet9!A1
[Book1]Sheet10!A1
These are just text strings


Step 3 make the validation pull-down
Click on A1
Pull-down:
Data Validation€¦ Allow List Source is
=$Z$1:$Z$10


Step 4 create a click-able version of A1
In A2 enter:
=HYPERLINK(A1)


Note that you are not limited to just A1 on the destination sheets. Make
the cell whatever you want. The Back button is always your way of returning.

I encourage you to play around with this a little

--
Gary's Student
gsnu200702


"oxicottin" wrote:

Gary thanks for the reply but im new to all of this so could you explain in
more detail? Thanks!!!

"Gary''s Student" wrote:

You can do better without VBA:

1. In an un-used column, create a set of hyperlinks to all your various sheets
2. in A1 put a simple data validation drop-down
3. In A2 put =HYPERLINK(A1) (this is click-able)

The advantage here is that you can always get back just by using the Back
button!
--
Gary's Student
gsnu200702


"oxicottin" wrote:

Hello, I want a control box that gives me a list of sheetsin my workbook. I
also want a button thats next to the controm box that says FIND and when
pressed it brings up the sheet that was selected from the control box. Also
is there a way it can always go back to the first sheet that has this control
box and button? This way its always like my cover sheet. Can someone help?