Finding a worksheet
Forget training them, apparently I need training. I did not know that one.
Does that also work in Office2003?
"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
It might be easier to use a listbox rather than option buttons.
Or train all your users to instead right-click on the sheet navigation
arrows at bottom-left....
Tim
"Patrick C. Simonds" wrote in message
...
I have a workbook which ranges from 40 to 55 worksheets, I thought it
would be helpful if I were to create a UserForm which would list the name
of all available worksheets (by be as a series of OptionButtons). The user
would then select the sheet they wanted to view next from the list and
that sheet would become active. Has anyone seen or done anything like
this?
|