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

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" wrote:

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

Thanks for your reply & instructions. However, I could not make them work.I
did not find any "Modules" in the "Project - VBAProject " window. I did find
Microsoft Excel Objectsnut nothing that says "Option Explicit". I get a list
of properties with a desigantion of True/False or 0 or other designation
that I do not recognize in the column next to it but I cannot select or
delete any of them. I have tried copying the original WS and the problem
exists there. Have also done a "Save as". then I opened a braond new totally
blank workbook and the problem exists there in B27 as well.
HELP!

"JLatham" wrote:

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" wrote:

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

Don't worry that you didn't find anything. I'd kind of expected that you
would, but if you didn't, you didn't.
Can you send me a copy of the file that started all of this? Attach it to
an email sent to (remove spaces) Help From @ jlathamsite.com
I'll take a look at it and see what I can find out with it in hand.

In the meantime, I suggest that you also run a thorough virus scan on your
computer. What anti-virus program do you have on it?

"Lindsay" wrote:

Thanks for your reply & instructions. However, I could not make them work.I
did not find any "Modules" in the "Project - VBAProject " window. I did find
Microsoft Excel Objectsnut nothing that says "Option Explicit". I get a list
of properties with a desigantion of True/False or 0 or other designation
that I do not recognize in the column next to it but I cannot select or
delete any of them. I have tried copying the original WS and the problem
exists there. Have also done a "Save as". then I opened a braond new totally
blank workbook and the problem exists there in B27 as well.
HELP!

"JLatham" wrote:

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" wrote:

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