software

I have a user with only one arm, and she needs to be able to group worksheets
in Excel. I know that you can right-click a sheet tab and choose quot;Select all
sheetsquot; from the menu, but what if she needs to select/group non-adjacent
sheets? She cannot Ctrl click with just one hand. Any suggestions would be
greatly appreciated!

TIA,
Steve Vincent
IT Trainer

Hi Steve,

How about a VBA procedure that creates a list box of sheet names that you
can select and group with the mouse.

You could tie it to a command or toolbar button that could be run with a
mouse click.

HTH

quot;Steve Vincentquot; wrote:

gt; I have a user with only one arm, and she needs to be able to group worksheets
gt; in Excel. I know that you can right-click a sheet tab and choose quot;Select all
gt; sheetsquot; from the menu, but what if she needs to select/group non-adjacent
gt; sheets? She cannot Ctrl click with just one hand. Any suggestions would be
gt; greatly appreciated!
gt;
gt; TIA,
gt; Steve Vincent
gt; IT Trainer

CTRL-SHIFT-PGDN or CTRL-SHIFT-PGUP will group the current tab with the
one immediately next to it, and additional presses will group
additional sheets. Unfortunately this method requires that sheets be
next to each other- I wasn't able to work out a way to choose
non-contiguous sheets. Sorry I couldn't be of more help!