random highlighting
Posted by Rich Gallagher on November 14, 2001 10:13 AM
One of my users is experiencing an issue where excel 2000 will randomly highlight cells (as if you are clicking and dragging to highlight) and follow the motion of your mouse pointer but will not allow you to click anywhere and no longer can you use any of the menu options. We end up having to use ctrl-alt-delete to end the task and start over. Anyone run into a similar situation?
Posted by Dan on November 14, 2001 10:20 AM
Yes, I've run in to that a few times with some users. I have not been able to identify a cause, but I have had to completely restart the computer to resolve the issue. Simply shutting down Excel and reopening didn't stop the problem.
Your guess is as good as mine....
Posted by Juan Pablo on November 14, 2001 10:34 AM
When that happens i've been able to resolve it by going to VB Editor, and in the inmediate panel try with one of
Range("A1").Select
ActiveCEll.Select
Range("A1").Activate
or other like that, and i'm back to normal
Juan Pablo
Posted by Namir on November 14, 2001 10:36 AM
All your virus software is updated, right?
-Namir
Posted by Juan Pablo on November 14, 2001 10:45 AM
Updated last week...NAV
Juan Pablo All your virus software is updated, right?
Posted by faster on November 14, 2001 11:00 AM
Juan Pablo : All your virus software is updated, right?
I have had it too. It looked more like a mouse driver
error. Click the desk top would highlight all
of the icons. Reboot.
Posted by Rich Gallagher on November 14, 2001 11:12 AM
Ive no idea if Dave does on line as such, try www.ozgrid.com and mail him tell Dave some guy in London told me he might be able to help or advise.
Also it depends on where you are Dave is Western Australia,
Pearson is Canada i think
Also search VB Training VBA is specialised thou but VB is the grounds to VBA, most in my company VB not VBA, so little old me is seen as an expert. VB and VBA are miles apart but also te same! Does anyone have a strong recommendation for a on-line training course for using VB with Excel.
Posted by Juan Pablo on November 14, 2001 11:20 AM
The solution i provided (using only keyboard):
Alt - F11,
Ctrl G (In spanish version, don't know in english)
Range("A1").Activate
[Enter]
Has worked for me.
Juan Pablo : Updated last week...NAV : Juan Pablo
Posted by Todd on November 14, 2001 12:00 PM
Hey,
I've had this happen too - both the desktop thing (all icons highlighted when clicking) and in Excel (highlights following mouse pointer).
I've found that tapping the SHIFT keys or ALT keys several times usually fixes the problem. It's almost like those keys are "sticking" without actually being physically stuck. The tapping "loosens" them. Voila!
My $0.02.... try it next time...
-Galto
Posted by Rich Gallagher on November 15, 2001 6:39 AM
I will, thanks! Hey, I've had this happen too - both the desktop thing (all icons highlighted when clicking) and in Excel (highlights following mouse pointer). I've found that tapping the SHIFT keys or ALT keys several times usually fixes the problem. It's almost like those keys are "sticking" without actually being physically stuck. The tapping "loosens" them. Voila! My $0.02.... try it next time... -Galto
Posted by Andy Miller on November 15, 2001 7:04 AM
By chance are you using a mouse with a wheel? Sometimes, for me, the wheel causes the problem because it gets stuck or something. Usually, tapping the mouse wheel will fix the problem.
