Hi Bryan,
This method didn't help, on the contrary it gave an entirely surprising
result: Cell formatting dialog doesn't come up even if entire column or row
is selected. I tried to copy the content into a separate workbook, the result
is the same. (XP, Excel2000).
Stefi
€˛Bryan Hessey€¯ ezt Ć*rta:
Not heard of this before, but if it's a single sheet you could Insert,
Worksheet, copy the old worksheet, select cell A1 on the new worksheet
and Paste Special, Values (assuming there was no intended formatting
transferred)
Stefi Wrote:
Hi All,
I have a workbook exported by Access. Selecting a unique cell or a
range of
cells the cell formatting doesn't work neither chosen from the menu
nor
right-clicking on the cell (the formatting dialog-box doesn't come up
at
all). Selecting an entire column or row cell formatting works
normally.
What is the cause of this and how to fix the problem?
Regards,
Stefi
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=392850