Unable to select multiple workbook sheets

D

David Ehler

I am using Excel 2k running under WinXP and have a problem I have never
encountered on any other version or machine. All my workbook tabs are white
instead of the default gray and only one sheet at a time can be selected.
Neither the Ctrl or shift keys or right clicking the tabs and selecting all
will allow multiple sheets to be selected. What am I missing here, I see
nothing in options that allows this configuration? Detect and repair does
not change the situation.
 
G

Gary Brown

If this is a new situation, could you have a Mouse Driver
compatability issue? I've heard of some interesting
things happening with Excel and WinXP. In particular, the
wheel on a mouse sometimes won't work in VBA. I solved
this by going to the support.Microsoft.com web site and
grabbing an old mouse driver.
Just my 2 cents.
HTH,
Gary Brown
 
R

Richard O. Neville

Don't know the cause, but may have a solution: unless there is a large
number of worksheets, right-click on the first one, select "Move or Copy,"
click "Make a copy," and copy it to a new workbook, which you should then
save. Repeat this process with each sheet tab, copying the second and later
ones to the newly saved document. After you have copied a few, see if your
problem disappears. If it does, copy the rest and delete the old document.
 
G

Gord Dibben

Gary

Perhaps the sheets are already grouped.

Do you see [group] up on the Title Bar?

If you right-clcik on a sheet do you have "Ungroup sheets" available?

Gord Dibben Excel MVP
 
Top