cannot add color to cells

A

acraddoc

using excel 2003

when you try to format cell and change font color the change shows up in
preview but once you click ok the highlighted text in the cell does not
change stays black

also

if you format highlighted cell before adding text change color then type
text the change appear but as soon as you change to new cell color goes back
to black

this has me stumped any help would be appreciated
 
N

Nick Hodge

It almost seems like you have a Worksheet_Change() event set up. Try
right-clicking on the sheet tab and selecting 'view code'. If there is code
here then that may be your problem.

This is probably not malicious so you should check with the owner of the
sheet before deleting the code.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
A

acraddoc

in terms of it possibly being malicious do you mean some type of macro virus?

also

does excel have an equivalent of normal.dot for word and if so where can I
find it?
 
N

Nick Hodge

Any startup settings can be customised in workbooks named sheet.xlt and
book.xlt in a folder called xlStart. They do not have to exist, but if they
do it overrides Excels defaults.

I said it may not be malicious, (virus) as the code could have fulfilled a
legitimate purpose in your organisation, so I did not want you to just
blindly delete code that someone had put there who, for example wanted to
stop formatting of a business model.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
D

Dave Peterson

I would guess that Nick wasn't suggesting a virus--but a macro that's trying to
be helpful by formatting your cells the way the developer of the macro thought
was correct. (Sometimes requirements change.)

Excel doesn't have the equivalent of Normal.dot, but there are workbooks where
macros are stored.

To find out if it's a misbehaving macro, try this:

Close excel
windows start button|run
excel /safe
(safe mode stops macros from running)

File|open your workbook

And try changing a cell or two. If the changes stick, it could be that
misbehaving macro. Can you find the developer to complain?
 
Top