Set treeView_PopupMenu suddenly failed (vba); cured by re starting windows7. Nasty shock - seek advice re explanation/prevention.
Hello,
In Excel 2010, I have recently built my first TreeView popup menu which enables procedures to be called when right clicking a tv node from a UserForm TreeView control. All was going fine ...
... Suddenly, earlier file versions (that worked well on previous days) FAILED at the following step:
Set treeView_PopupMenu = Application.CommandBars.Ad
Position:=msoBarPopup, _
Temporary:=True)
Blood running cold - I re-started Windows 7 - and the problem disappeared.
I have no clues re the failure, but does the evidence suggest the cause was outside the excel piece?
Has anyone had this experience? My piece is intended for distribution. I hope to understand what happened, to head-off the problem if possible, or arrange for a less disconcerting crash.
Can I do better than put in an error trap that directs the user to restart the computer?
I have continual AVG anti-viral cover. I carry our occasional checks with SuperAntiSpyware (http://www.superantispyware.com/downloadfile.html?productid=SUPERANTISPYWAREFREE), but it was not on when this occurred.
I had to restart my PC yesterday because my old Logitech cordless mouse failed to drive the cursor (though it had a new battery).
The machine is not used for games/ TV, just work. My browser is google chrome.
Thanks
Kelvin
In Excel 2010, I have recently built my first TreeView popup menu which enables procedures to be called when right clicking a tv node from a UserForm TreeView control. All was going fine ...
... Suddenly, earlier file versions (that worked well on previous days) FAILED at the following step:
Set treeView_PopupMenu = Application.CommandBars.Ad
Position:=msoBarPopup, _
Temporary:=True)
Blood running cold - I re-started Windows 7 - and the problem disappeared.
I have no clues re the failure, but does the evidence suggest the cause was outside the excel piece?
Has anyone had this experience? My piece is intended for distribution. I hope to understand what happened, to head-off the problem if possible, or arrange for a less disconcerting crash.
Can I do better than put in an error trap that directs the user to restart the computer?
I have continual AVG anti-viral cover. I carry our occasional checks with SuperAntiSpyware (http://www.superantispyware.com/downloadfile.html?productid=SUPERANTISPYWAREFREE), but it was not on when this occurred.
I had to restart my PC yesterday because my old Logitech cordless mouse failed to drive the cursor (though it had a new battery).
The machine is not used for games/ TV, just work. My browser is google chrome.
Thanks
Kelvin
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
DrTribos,
Also, pening the two versions in the same workbook caused no failure, Thanks.
Also, pening the two versions in the same workbook caused no failure, Thanks.
Well - it's nice to be able to rule some things out too I guess ;-)
The only other things I can think of are:
- it was a co-incidence, office applications sometimes crash (not very helpful, but possibly the right answer)
- were you using break'points in your code for debugging, sometimes I've managed to crash word with a carefully placed breakpoint ;-)
- were there any other add-ins that might have been interfering with your code?
The only other things I can think of are:
- it was a co-incidence, office applications sometimes crash (not very helpful, but possibly the right answer)
- were you using break'points in your code for debugging, sometimes I've managed to crash word with a carefully placed breakpoint ;-)
- were there any other add-ins that might have been interfering with your code?
ASKER
Thanks.
Will await other contributions; noted that yours was first!
K
Will await other contributions; noted that yours was first!
K
No worries, I'm out of ideas - hope you find a root cause. Cheers,
ASKER
This was an open question, trawling for defensive ideas.
Thanks, Dr Tribos, for sharing your thoughts. As you say, maybe the crash was coincidence.
The problem did not ring any bells with others.
Cheers!!
Kelkin
Thanks, Dr Tribos, for sharing your thoughts. As you say, maybe the crash was coincidence.
The problem did not ring any bells with others.
Cheers!!
Kelkin
ASKER
I opened two excel file versions which were 99.99% identical (differing in file name and just a few lines of vba code). Was that as fair test of your point? In the event, the files behaved perfectly regarding the operation of the tv popUp menu. But I appreciate your suggestion. Kelvin