Strange... in my worksheet, if I choose Format | Cells from the menu
(or press Ctrl+1), the Format Cells dialog box won't display. The only
time it will display is if I've selected all the cells at once
(Ctrl+a). This is of course a problem if I want to change the format
of any individual or group of cells. Has anyone ever heard of this?
Even after (via Ctlr+a then Ctrl+1) I uncheck "Locked" on the
protection tab, I still can't format individual cells.

A couple possible reasons: (1) the worksheet is a table that was
created from Access by pressing "Analyze with Excel" so maybe there's a
special setting or something which locks formatting, (2) the worksheet
was initially saved in Excel 2003 and I'm opening it in Excel 2000,
however, even when I copy the cells into a new workbook, the Format
Cells dialog box still won't display for those cells.

Thanks.

Hello Dave,

I have never encountered this problem nor heard of it happening. If
this is happenong only with this workbook, I would agree with you on
the table being created from Access being the problem. You didn't say
in your post if the Format|Cells... was grayed out at all, but I am
assuming the answer is no. Try creating a second workbook with an
Access table an see if you get the same result.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=494356