Serious problem with Excel!! Can't exit design mode...

aaronhowe · May 5th, 2004, 01:54 PM

I'm getting an error on my sheet today, after I removed a combo box and replaced it with another combo box. I gather that though I had Activex working when I created the sheet, at the time of editing it hadn't been registered properly and this may have caused the issue.

I have been through all the code I can find and I can't locate the combo box it's referring to, however some digging in VBA did locate something:

Library: VBAProject
Class:Sheet6
Membcombobox10er:Combobox10

This is the one it's saying it can't create in order to exit design mode. Does anyone have a clue on how to remove it?!!!!! Please help! I'm desperate!!!

May 5th, 2004, 01:54 PM	#1
aaronhowe Join Date: Oct 2002 Posts: 34	Serious problem with Excel!! Can't exit design mode... I'm getting an error on my sheet today, after I removed a combo box and replaced it with another combo box. I gather that though I had Activex working when I created the sheet, at the time of editing it hadn't been registered properly and this may have caused the issue. I have been through all the code I can find and I can't locate the combo box it's referring to, however some digging in VBA did locate something: Library: VBAProject Class:Sheet6 Membcombobox10er:Combobox10 This is the one it's saying it can't create in order to exit design mode. Does anyone have a clue on how to remove it?!!!!! Please help! I'm desperate!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode