accessing built in dialog boxes
Posted by jim c on January 29, 2001 7:28 PM
I am trying to build a table of contents for my workbook. I have tried several different methods and came across the built in dialog box when you right click the worksheet arrows in the lower left. This will probably work, but I have 60-80 worksheets in this particular application and the user has to scroll through quite a long list. Is there another way to display a directory of worksheets or a way may be to make the built in dialog box bigger so I don't have to scroll Thanks for the help
Posted by Dave Hawley on January 30, 2001 4:42 AM
Hi jim
As far as I'm aware this dialog cannot be displayed any other way, except right clicking on the "Tab scrolling buttons".
You could create a sheet specifically for the purpose of placing "Hyplinks" to other sheets on it. I could probably even write some code for you, that will do this if interested ?
....Or a userform with a ListBox filled with all sheet names ?
What do you think ?
Dave
OzGrid Business Applications
