Excel sheets
 

Is there a way to create a dockable list of the sheets in an Excel
file? I work with various Excel files that have numerous sheets with
long tab name and it is painful tabbing. Is the list that comes up on
righting clicking by the directional arrows dockable or vba coding
required to accomplish this task? Thanks for any help.

Excel sheets
 

You can right click the arrows down at the bottom left which will bring up a
list of all sheets, that may be the best for what you are wanting

"Probyn" wrote:

Is there a way to create a dockable list of the sheets in an Excel
file? I work with various Excel files that have numerous sheets with
long tab name and it is painful tabbing. Is the list that comes up on
righting clicking by the directional arrows dockable or vba coding
required to accomplish this task? Thanks for any help.

Excel sheets
 

I don't think that is undockable. I created an addin just for that kind of
thing. Give it a shot and see if it will work for your needs.

http://www.graceba.net/~wmivey/Workbook%20Navigator/

The zipped file has instructions and an "Addin Setup Utility" for easy
install.

I think I have all the bugs worked out in it, but please let me know if you
have any problems.

Mark Ivey



"Probyn" wrote in message
ups.com...
Is there a way to create a dockable list of the sheets in an Excel
file? I work with various Excel files that have numerous sheets with
long tab name and it is painful tabbing. Is the list that comes up on
righting clicking by the directional arrows dockable or vba coding
required to accomplish this task? Thanks for any help.

Excel sheets
 

Thanks Mark this is a very powerful macro and I thank you. I really
need to be able to dock this or keep it on top. Thanks.



Mark Ivey wrote:
I don't think that is undockable. I created an addin just for that kind of
thing. Give it a shot and see if it will work for your needs.

http://www.graceba.net/~wmivey/Workbook%20Navigator/

The zipped file has instructions and an "Addin Setup Utility" for easy
install.

I think I have all the bugs worked out in it, but please let me know if you
have any problems.

Mark Ivey



"Probyn" wrote in message
ups.com...
Is there a way to create a dockable list of the sheets in an Excel
file? I work with various Excel files that have numerous sheets with
long tab name and it is painful tabbing. Is the list that comes up on
righting clicking by the directional arrows dockable or vba coding
required to accomplish this task? Thanks for any help.