View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
 
Posts: 459
Default Crashes when I delete Control

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

--

"Darren Hill" 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