sort command

[Lady Layla]

Shared workbooks can be sorted.

: I'm sure your worksheet is shared then. If you click on Tools|Protection, do
: you have as a last option Protect Shared Workbook, which is not grayed out?
: If so, the workbook is shared.
:
: "Chip Pearson" wrote:
:
: > Is the worksheet protected? You normally can't sort protected
: > worksheets.
: >
: >
: > --
: > Cordially,
: > Chip Pearson
: > Microsoft MVP - Excel
: > Pearson Software Consulting, LLC
: > www.cpearson.com
: >
: >
: > : > > my sort command is not active (grayed out)
: > >
: >
: >
: >

 

[Joe McManemin]

my sort command is not active (grayed out)

 

[Kassie]

Most likely your worksheet is protected. Click on Tools|Protection and then

 

[Chip Pearson]

Is the worksheet protected? You normally can't sort protected
worksheets.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Joe McManemin]

Tools - Protection - Protect Sheet is also grayed out.
There is no Unprotect option.

 

[Chip Pearson]

Is the workbook shared?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Gord Dibben]

Joe

Do you have more than one sheet selected?

Do you see [Group] in the title bar?

If so, right-click on a tab and "ungroup" or just select any sheet tab.


Gord Dibben Excel MVP

 

[Kassie]

I'm sure your worksheet is shared then. If you click on Tools|Protection, do
you have as a last option Protect Shared Workbook, which is not grayed out?
If so, the workbook is shared.

 

[Joe McManemin]

That was it! Thanks. I ungrouped and all my commands are now active.

Joe

Do you have more than one sheet selected?

Do you see [Group] in the title bar?

If so, right-click on a tab and "ungroup" or just select any sheet tab.


Gord Dibben Excel MVP

Tools - Protection - Protect Sheet is also grayed out.
There is no Unprotect option.