LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Excel Freezes When moving from UserFrom to Excel Spreadsheet

Does that userform have a RefEdit control on it ?

NickHK

wrote in message
oups.com...
When I try that the first thing I get is an error message that says
this action will reset your project, and then I get an unexpected Excel
error that shuts Excel down. It's almost as if something is running to
begin with, that is getting interupted.

I then re-opened the worksheet, but this time disabled the macros. I
then ran CodeCleaner again, and it worked (And also decreased my file
size by almost 300k, so thanks!)...

But the problem still remains. Its almost like something is running in
the background, just by opening up the spreadsheet. But I have no idea
what, and if I hit the break or stop button nothing happens. It seems
to get hung up when I toggle from just that UserForm.


RB Smissaert wrote:
Try running the free VBA CodeCleaner that you can download from:
http://www.appspro.com/Utilities/CodeCleaner.htm

RBS


wrote in message
oups.com...
I was wondering if anyone else ever runs into this problem, and if so
what causes it, and how to fix it.

When I am in the Microsoft Visual Basic Window, there is one form that
causes excel to freeze (excel.exe resource shoot to 99%), forcing me

to

shut down excel manually, and lose any changes. This only occurs if I
have that form visible and I toggle from the form back to the
spreadsheet. There are no problems/errors running the user form. It
occurs only when I am working in the VB Window and toggle back to the
Excel spreadsheet window.


It does not occur with any other UserForm, or when the code is

showing.

Only when I'm on this particular userform.


Since there is no code running, I don't understand what causes this.
Is somethign compiling in the background everytime I switch back to
Excel? I've done some research, I've done the help / detect and

repair

thing. I don't get any error messages, and no errors are present in
the code.


Any input is greatly appreciated as I keep losing work...


Thanks




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving spreadsheet rows with photos Problems in Excel 2007 Sprog New Users to Excel 0 December 5th 08 07:17 PM
Moving Outlook Contacts to Excel Spreadsheet Terry@FA Excel Discussion (Misc queries) 0 May 14th 08 11:12 PM
Macro freezes spreadsheet davemel Excel Discussion (Misc queries) 0 August 1st 06 08:26 AM
moving data from excel spreadsheet to word document HeatherO Excel Programming 3 February 20th 05 01:40 AM
Userfrom code in written in Excel 2000 running in Excel 97 KimberlyC Excel Programming 1 February 11th 04 08:45 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"