Hi Forum followers,

I have faced problem with Control box in Developer tab in Excel 2010.

The problem is, I cannot Insert new controls and edit existing controls in my work sheet since the Developer tab > Control > Insert icon was disabled. I looked into many forum threads but didn't get the solution how to enable this control until I went to VBA code written for that worksheet.

If we want to enable the Control Insert, we need to check the VBA code similar to below:
Example: "Sheets(Sheet1).Protect DrawingObjects:=True, ......."
Now check under which module or event are we calling/executing this code. Example: This code is in Mudule1() on some Button1_Click()

Please comment the above example line and add below code until you complete your design of excel worksheet:
Example: "Sheets(mSheet1).Unprotect"
Now save and run the Button1_Click() by clicking on the respective button, you will see the Control > Insert in Developer tab enabled.

Once you are done with your testing, uncomment the ".Protect" mode in VBA which was commented earlier and remove the ".Unprotect" line of code.

Hope this information is useful!

Thanks for reading!
Pradeep