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

[aaronhowe]

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!!!

 

[aaronhowe]

Answering my own post, I have had to copy out everything and paste it into a new sheet as there seems to be no logical way to deal with this issue.

 

[Tom Urtis]

You might have that cbo on a sheet that is hidden or VeryHidden. The Sheet6 ref looks like that is the VBA object number, not necessarily the name of the worksheet's tab. Hit Alt+F11, then Ctrl+R, double-click on the bolded name of your workbook in the project pane, and see what sheet tab name is assigned to Sheet6 of your workbook. Then hit Alt+Q to return to the worksheet. If that sheet is not visible, then click on Format > Sheets > Unhide and see if you can unhide it there. If it isn't listed in the Unhide dialog, go back to the VBE and run a macro like this:

Sub Test2()
Sheet6.Visible = xlSheetVisible
End Sub

That will make Sheet6 appear and the cbo will be there, all assuming the correctness of this theory that it exists on a hidden sheet whose object number is 6. Worth a shot.