pcc
Well-known Member
- Joined
- Jan 21, 2003
- Messages
- 1,353
I am using Excel 2002 (Don't laugh!). I run a lot of VB code, most of which involves loading and unloading userforms, connecting to (eg) MS Access, etc, so all in all I give Excel a pretty hard ride. Sometimes (and I can't pin down any specific things that seem to cause this to happen), when code execution has completed, the leftmost (approximately 20%) of the working area of whichever sheet is uppermost is greyed out. That is, the row numbers are not visible, and the column numbers (those that fall within this area) are not visible either, There is just a pale grey rectangle where there should not be! Changing worksheets does not remove it, nor does adding new workbooks or opening other workbooks. The only way to get rid of it is to close the whole Excel app and re-open it.
I have lived with this for some time but it is annoying. Can anyone suggest a reason as to why this might be happening, and, more importantly, how to prevent it?
All suggestion welcomed.
Regards
I have lived with this for some time but it is annoying. Can anyone suggest a reason as to why this might be happening, and, more importantly, how to prevent it?
All suggestion welcomed.
Regards