Embeded Form Control Combo Box, works for some users but not others


New Member
Dec 12, 2014
So here is my bit of fun (Windows 7 64-bit, Excel 2010 v14.0.7140.5002 32-bit):

We have a spreadsheet used for sizing products provided to us.

Within the spreadsheet are drop down list. These list are apparently made using Form Control - Combo Box.

For "John", everything was working fine. For reasons I don't know, it no longer works. Clicking on the drop down list is now like clicking into empty space. Nothing at all happens. I can manage to click on and grab the drop down list by first enabling Design Mode. However that only allows me to move the list, not make it function.

What I have tested:
1) Tried it on a different computer in Excel 2013, Works.
2) Tried it on my own PC under my user name, Fails.
3) Tried in on two different users on my PC, one Administrator, one Standard user, Works on both.
4) Tried on a different user account on "John's" pc, Works.

So the two points of failure are on "John" on his PC and on me on my PC, otherwise the drop downs seem to work fine.

Tried to repair Excel/Office to see if it was a settings issue. No change.
All I can tell at the moment is that it doesn't seem to be a permission issue or an issue between versions of Excel. Yet there is something different within our user accounts where it stops working.

Other information:
This is a protected workbook by the creator, but it still works on other PCs as long as a click enable editing. We do click enable editing on all users and PCs, do that doesn't seem to be a common denominator, unless something about that setting is not behaving as expected.
In case anyone ask, I sadly can only provide you information and I cannot share the workbook online as it is the IP of someone else and we do not have permission to share it.
Please reply if there is any other information I can provide that will help with this.

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest


New Member
Dec 12, 2014
OMG, thank you, thank you, ..............., seriously, thank you.

I didn't even think this would work because its a form control and not an activeX control but it did work, so WOOT!!

Have a great day.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...