MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Entire row turns black when data entered into a cell


Posted by cooper on July 19, 2001 9:08 AM

I am using Excel 98 on the Mac and am working with a complicated worksheet that has macros. Whenever I enter data in a cell and hit return the entire cell goes black so that I can't read it. Curiosly if I resize the window, all the black garbage goes away and I can read everything perfectly, including the data I just entered in the cell. As you can imagine, I'm a little sick of resizing windows.Please help!


Posted by Mark W. on July 19, 2001 10:06 AM

Does this happen if you disable the marcos?

Posted by cooper on July 19, 2001 10:43 AM

I'm actually not sure how to disable them (you can tell that I didn't create this workbook)

Posted by Mark W. on July 19, 2001 11:05 AM

Choose the Tools | Preferences... menu command, and
check the "Macro virus protection" check box on the
General tab. Quit Excel and re-open the workbook.
When prompted do not enable the macro and see what
happens.

Posted by Cooper on July 19, 2001 11:31 AM

When I tried disabling macros it gives me the message "This workbook contains a type of macro (Microsoft Excel Version 4.0) tha cannot be disabled"....

Posted by Mark W. on July 19, 2001 12:07 PM

Is the macro hidden? Use the Format | Sheet | Unhide...
menu command to check.

Posted by Cooper on July 19, 2001 12:39 PM

When I do unhide I am able to see a list that appears to be some sort of macros

Posted by Mark W. on July 20, 2001 6:05 AM

Make a copy of your workbook, eliminate the macros,
Save and reopen to see if they're the cause of your
problem.