Excel not creating OLEObjects

Lampshade14

New Member
Joined
Jul 19, 2011
Messages
1
Hi all, i've read your forums a lot in the past, never had to post since the answer is uaually already here. You guys have taught me lots, thanks for your knowledge already.

So here's my problem. I have an excel sheet that's saved on a network drive and used on 20+ comptuers(Win XP SP3/Excel2003). There is one master sheet that is copied and opened using a command prompt script. On 2 of the computers, excel fails to load any OLEObjects(Combobox's and CommandButton's). I have a workbook open routine that does not compile because the "Method or Data Member Does not exist". This is happening when setting the listfillrange for a combobox. If i block out that part of code, it will run the full workbook open routine, then fail the next time any OLEObject is referenced in code. The Objects are visable on the sheet, however they can not be selected in any way.

I have other sheets that use shapes with assigned macro's, these work correctly. Any sheets with OLEObjects in VBA code has issues, i just created a sheet that has a combobox named CBTEST, and the workbook open routine of:

Code:
Private Sub Workbook_Open()
    Sheet1.CBTEST.ListFillRange = "K1:K26"
End Sub

This failed on a compile error as well.

Here's what i've tried:
Reinstall excel
Save sheet to local computer(see if network drive issue)
run office repair
Remove workbook open routine to let sheet load
Have excel open before opening sheet
Replaced a computer that had this issue last week(This Worked!)

Any idea's or suggestions would be great, thanks in advance.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,224,618
Messages
6,179,916
Members
452,949
Latest member
beartooth91

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