Excel - Cannot Insert Object (ComboBox)

[mavest]

I've got an Excel workbook that does some complicated calculations involving VBA and has alot of named ranges, VBA code, and Control objects such as command buttons, comboboxes, etc.

All of a sudden none of the worksheets will allow me to insert a ComboBox or any other control. This is greatly affecting the user's ability to enter data.

Excel flashes a message box stating:
"Cannot insert object."

Is there any solution to this problem? Has my workbook become corrupted? If it is corrupted is there any recovery? Thanks for your help!

 

[SkipVought]

Hi,

Do you have something selected other than a sheet?

I'd recommend coding that explicitly references objects, rather than Selection.

Other than that, you might post your code.

Skip,

_[red][/red]

 

[mavest]

Thanks for your try, but coding is not involved. The problem is when I manually try and insert an object like a ComboBox or Command Button onto a worksheet. I've checked if the workbook or sheet was protected and no - they are unprotected. This problem does not involve any coding, but obviously impacts the project.

Background:
I am manually inserting these on a worksheet to create user data entry. Based on the results of the user entries, the VBA will do different things, such as control another application doing calculations.

 

[PHV]

coding is not involved
So, you're in a wrong forum.
Try forum68

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886