Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unsolicited grey shaded are on the screen
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unsolicited grey shaded are on the screen
Hi Marmo,
Thanks for the suggestion. Ok, i'll give it a go, sounds a wierd potential solution, but hey if it works!! John "MarMo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grey text not printing | Excel Discussion (Misc queries) | |||
Printing Grid lines & Shaded cells | Excel Discussion (Misc queries) | |||
Some borders show on the screen as grey, when the colour is black. | Excel Worksheet Functions | |||
Excel screen grey | Excel Discussion (Misc queries) | |||
My document opens but all I see is a grey screen. | Excel Discussion (Misc queries) |