Excel in cell editing

[Michael Woerner]

Hi,
My version of excel has developed this problem of briefly showing the
contents of a cell when I double-click it. I get to see the formula or
whatever for about a second and then the cell goes blank. The contents
are still there but I just can't see them. Yes, I have in cell editing
selected in the preferences. Any ideas?
Michael

 

[Dave Peterson]

It kind of sounds like an event macro firing.

You may want to open excel in safe mode to disable all the macros.

Close excel
windows start button
run
excel /safe

Open your workbook and see if that helps.

If it stopped the behavior, you'll have some detective work to do.

Rightclick on the worksheet that has this behavior and select view code. If you
see stuff in there, you'll have to decide if it can be deleted/fixed. (You can
post back with followup questions if you have them.)

If you don't find anything there, then look in the module under ThisWorkbook,
too and in General modules, on top of that.

If you've never visited the VBE (where macros live), Debra Dalgleish has some
nice pictures at:
http://www.contextures.com/xlfaqMac.html#NoMacros

This site actually has instructions for removing code--too drastic to start, but
it might be useful just to help you feel more familiar with the VBE.