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

A

aaronhowe

New Member
Joined
Oct 16, 2002
Messages
34
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!!!
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
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.
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Can' Exit Design Mode Because Control 'xxx' can not be created
Replies
3
Views
648
Dan_W
D
P
  • Question Question
Exiting a Textbox Problem
2
Replies
10
Views
688
Pacman52
P
B
  • Question Question
Can't Exit Desing Mode because Control 'xxxx' can not be created
Replies
1
Views
442
ktwwtk
K
VinceF
  • Solved
Save With Date
Replies
7
Views
91
VinceF
VinceF
brendalpzm
  • Solved
How to change EMBED name of an ActiveX Combo Box?
Replies
3
Views
1K
brendalpzm
brendalpzm

Forum statistics

Threads
1,223,888
Messages
6,175,203
Members
452,617
Latest member
Narendra Babu D

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top