I have received a spreadsheet that does not appear to have any protection on,
but I cant get the cell formatting dialogue box to open (ctrl+1). Any ideas
as to why this would be? (Both parties using the same version of excel 2000)

Thanks

The only time I've seen this is when the original workbook was created in a
different program--crystal reports or Lotus 123.

I included a few "sacrificial" cells in my selection, made my changes to all of
them.

Then went back and fixed the sacrificial cells to the way they were supposed to
be. (Try a cell way out of the way of where the data really is.)

Swan wrote:

I have received a spreadsheet that does not appear to have any protection on,
but I cant get the cell formatting dialogue box to open (ctrl+1). Any ideas
as to why this would be? (Both parties using the same version of excel 2000)

Thanks

--

Dave Peterson