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.
