Not totally sure what you were asking for...

"Question: Is there a way to make it so it goes to the file on a single
click. I have tried a few things with no success."

Are you wanting it to launch after selecting the Worksheet (without the need
for a commandbutton)?

If so, you could play with the AfterUpdate feature for that particular
ListBox in the userform module.

Mark Ivey

"Steven" wrote in message
...
Incredible. Thank you. I am working on just clicking the listbox1 so it
is
fast ... I commented out where the user must pick the sheet. I will just
accept the sheet where the file is currently.

Question: Is there a way to make it so it goes to the file on a single
click. I have tried a few things with no success.

Thanks for your help. This is a very nice feature.

Steven

"Mark Ivey" wrote:

What version of Excel are you using? The one I designed was for Excel
2003,
but it also seems to work fine in Excel 2007.

Here are some brief instructions on how to build the version I built.
After
you get it working, it shouldn't be difficult to turn it into a VBA type
addin.

http://www.graceba.net/~wmivey/Workb..._navigator.htm

Let me know if you need any help.

Mark Ivey


"Steven" wrote in message
...
Mark,

Thank you for repsponding. Is this something you can post here? I am
at
work and cannot recieve emails from this website's contacts. If you
cannot
put the code in a response, can you get me going in the right direction
conceptually?

Thank you,

Steven

"Mark Ivey" wrote:

Are you talking about navigating between open workbooks?

If so... you can use an CNTL + TAB command to quickly navigate from
workbook
to workbook...

If you want a popup window, I think I saw an addin on the web you
could
purchase.

I actually created another version of my own.

If you are interested in trying out the version I made, just let me
know
and
I will see about sending you a copy.

Mark Ivey

"Steven" wrote in message
...
Is there a faster way to pick a window than to go to the Menu bar.
It
would
be nice if there was a fast way to make a popup come up in the
middle
of
the
screen with the names of the open windows on it to select. Going to
the
Menu
bar is a bit cumbersome.

Thank you for your help,

Steven