Sheet Protection turned on?
Two or more sheets are "Grouped"? Do you see [group] next to the filename in
the title bar?
If so, to ungroup click on a sheet not in the group(white tabs indicate
grouped sheets) or right-click on any tab and "Ungroup sheets".
Gord Dibben Excel MVP