Shared workbooks can be sorted.

"Kassie" wrote in message
...
: 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
:
:
: "Joe McManemin" wrote in message
: ...
: my sort command is not active (grayed out)
:
:
:
:

sort command
 

my sort command is not active (grayed out)

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

"Joe McManemin" wrote:

my sort command is not active (grayed out)

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" wrote in message
...
my sort command is not active (grayed out)

Tools - Protection - Protect Sheet is also grayed out.
There is no Unprotect option.
"Kassie" wrote in message
...
Most likely your worksheet is protected. Click on Tools|Protection and
then
on Unprotect Sheet

"Joe McManemin" wrote:

my sort command is not active (grayed out)

Is the workbook shared?


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

"Joe McManemin" wrote in message
...
Tools - Protection - Protect Sheet is also grayed out.
There is no Unprotect option.
"Kassie" wrote in message
...
Most likely your worksheet is protected. Click on
Tools|Protection and then
on Unprotect Sheet

"Joe McManemin" wrote:

my sort command is not active (grayed out)

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

On Wed, 30 Mar 2005 14:50:31 -0500, "Joe McManemin"
wrote:

Tools - Protection - Protect Sheet is also grayed out.
There is no Unprotect option.
"Kassie" wrote in message
...
Most likely your worksheet is protected. Click on Tools|Protection and
then
on Unprotect Sheet

"Joe McManemin" wrote:

my sort command is not active (grayed out)

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


"Joe McManemin" wrote in message
...
my sort command is not active (grayed out)

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Wed, 30 Mar 2005 14:50:31 -0500, "Joe McManemin"
wrote:

Tools - Protection - Protect Sheet is also grayed out.
There is no Unprotect option.
"Kassie" wrote in message
...
Most likely your worksheet is protected. Click on Tools|Protection and
then
on Unprotect Sheet

"Joe McManemin" wrote:

my sort command is not active (grayed out)