Sounds a bit like you may have inadvertently recorded a macro (or otherwise
gotten one) that is setting up that cell. That way. Since it is appearing on
new worksheets (which I assume you are adding using Insert | Worksheet, and
not by copying a worksheet already messed up this way), I'd suspect a
workbook event level macro such as Workbook_SheetActivate() to be a possible
culprit.
Here is how to find out if this is the cause of your problem. Make a copy
of your workbook (or open it and use Save As to give it a new name). Working
with the copy/renamed version, press [Alt]+[F11] to open the Visual Basic
Editor (VBE). look for a window in it named "Project - VBAProject". That
window will have some entries like you'd see in your file browser. If it has
an entry named Modules, expand that and you'll see any code modules in the
workbook - these things hold general purpose macro code. Those shouldn't be
a problem even if they exist. But just to be sure, right click on each of
them and choose the "Remove ..." option, where ... is the name of the module.
When it asks if you want to Export the module before deleting it, just say
no. Repeat for all modules you see.
Look for the entry called Microsoft Excel Objects and expand it.
Double-click on the "ThisWorkbook" entry. If there is any code other than
possibly a line that reads 'Option Explicit' then that code could be the
cause of it. Select and delete all the code you see. Repeat this for all of
the worksheets in the workbook. Any of them may have code attached to them.
Again select all the code you see and [Del] it.
Once you've done all of this code removal, the workbook should operate
normally. It will have lost an added automation features it might have had
by way of the code in it. Test to see if it's working right by closing the
VBE and using Insert | Worksheet from the main Excel window menu and checking
to see if B27 is acting strange in the new sheet. If it's ok, go try
selecting the other sheets and cell B27 on them and using Edit | Clear | All
to get rid of their odd properties also.
Is this only happening in one Excel workbook or in new ones also?
Lindsay said:
Somehow a particular cell in Excel - cell B27 - any worksheet, even new ones
- has somehow been set with a message that wants me to email the contents of
the cell and it changes my formatting. the color goes to blue and the
contents are underlined. One lick takes me to my email. I cannot delete or
Clear the contents of the cell