Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving spreadsheet rows with photos Problems in Excel 2007 | New Users to Excel | |||
Moving Outlook Contacts to Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Macro freezes spreadsheet | Excel Discussion (Misc queries) | |||
moving data from excel spreadsheet to word document | Excel Programming | |||
Userfrom code in written in Excel 2000 running in Excel 97 | Excel Programming |