That did the trick, thanks a million!!!

"Gord Dibben" wrote:

This would indicate that the workbook is Shared.

ToolsShare Workbook.

Uncheck the "allow changes etc." option.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 10:21:03 -0700, Cara wrote:

Unprotect is not an option but neither is protect. It's odd but a lot of the
options that are standard on all sheets are grayed out on this one.

"Peo Sjoblom" wrote:

Is the sheet protected? (toolsprotection)

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Cara" wrote in message
...
I need to ungroup cells but group and ungroup are both grayed out options.
Why would that be and how can I ungroup?