Crashes when I delete Control

  • Thread starter Thread starter Darren Hill
  • Start date Start date
D

Darren Hill

[Excel 2000]
I have a form containing a button that I no longer need. After running
CodeCleaner, I delete this button, compile the project and save.
When I then start up the form, a macro runs to initialise a class module -
and crashes at the line:

For each Ctl in frmManager.Controls

When I shut down excel and start up again, the file will not open.

If I don't delete the button (which incidentally is not part of the
aforementioned class group), it works fine.

Has anyone any suggestions - this is driving me mad!

Darren
 
Have you tried exporting the form, removing it from the project, then
re-importing the form from file?
 
Yes, unfortunately the error still occurred.
What I have just tried is - create a new form. Copy all the controls except
the problem one over to it. Copy all Code over. Save. Delete old form. Save.
Shut down. Boot up. Pray the file opens. Yess!! Rename new form to old form.
Save.
At the moment it seems to have worked.

--
Darren
onedaywhen said:
Have you tried exporting the form, removing it from the project, then
re-importing the form from file?

--

"Darren Hill" <[email protected]> wrote in message
[Excel 2000]
I have a form containing a button that I no longer need. After running
CodeCleaner, I delete this button, compile the project and save.
When I then start up the form, a macro runs to initialise a class module -
and crashes at the line:

For each Ctl in frmManager.Controls

When I shut down excel and start up again, the file will not open.

If I don't delete the button (which incidentally is not part of the
aforementioned class group), it works fine.

Has anyone any suggestions - this is driving me mad!

Darren
Click to expand...
Click to expand...
 
Back
Top