Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel not responding
- Thread starter eddy556
- Start date
TomCologne
Technical User
- Apr 18, 2002
- 628
Holding down the Shift key when opening might help, I'm not sure.
What should work is setting the Excel Security level to "medium" and then select the "Disable Macros" option.
Try looping through your code then or use the debugger.
TomCologne
You must have one of two things in your Personal Macro workbook, or either with a particular workbook:
1. A whole lot of code, or some really slow code in the _Open method of the workbook(s)
or (and this is my guess, at least in part)
2. Too many "add-ins" loading with Excel. I know that, from experience, if you start loading all sorts of add-ins with Excel, it can start running quite slow, and if your machine is slow enough, it could even freeze up Excel!
I hope that helps at least an itty-bitty bit!![[wink]](/data/assets/smilies/wink.gif "[wink] [wink]")
--
"If to err is human, then I must be some kind of human!" -Me
1. A whole lot of code, or some really slow code in the _Open method of the workbook(s)
or (and this is my guess, at least in part)
2. Too many "add-ins" loading with Excel. I know that, from experience, if you start loading all sorts of add-ins with Excel, it can start running quite slow, and if your machine is slow enough, it could even freeze up Excel!
I hope that helps at least an itty-bitty bit!
--
"If to err is human, then I must be some kind of human!" -Me
- Status
Similar threads
- Locked
- Question