View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MarMo MarMo is offline
external usenet poster
 
Posts: 34
Default Unsolicited grey shaded are on the screen

hi john ,

don't know if this helps.
I had the same problem before , but for the moment it seemed to have
stopped.
I had to provide "Option Explicit" at the top and declare all of my
variables , and this for every sheet or module in the Microsoft Visual
Basic Editor.
Until now the problem did not occur anymore.
It sounds stupid , but it helped me.

Maybe other people have other solutions.

MarMo

"John" wrote in message
...
Hi,

Not sure which of the XL forums to put this in, so thought i'd start here.
After i run quite a lengthy VBA procuedure, i get a light grey shaded are
appearing from top to bottom on the screen, and covering from left to
right
about 10% of the screen.

Course, this might not be an Xl issue, could be Windows issue. Has anyone
ever had this before and if so what (if any) was the solution.

It's intermitent which probably doesnt help!

Thanks

John