User form - Spreadsheet control

[ericontheroad]

Hi
I created an add-in which I want to share with colleagues.
The add-in contains Userforms with spreadhseet controls. When setting that up for myself initially I selected the proper Microsoft Office Spreadsheet 11.0 from the "Additional Control toolbox " dialogue box.
When other users attempt to use the add-in and open this "spreadhseet" form, they get a message that the object doesn't exist on their machine. When viewing the user form from their PC, it appears empty.

I attempted to resolve this by adding the Microsoft Office Spreadsheet 11.0 on each users machine but I'm still getting an error and they still can't view the form. We're all using the same Office version.
I just discovered this control box item. It fits exactly what I needed and would love to use it.

Would anyone know what other step I should follow to share these userforms?

appreciate any input.
thanks
​

 

[sijpie]

What do you mean with 'this control box item'?

How does the add-in (try to) open the required spreadsheet?

please post this part of the code.

 

[RoryA]

I attempted to resolve this by adding the Microsoft Office Spreadsheet 11.0 on each users machine

Can you clarify exactly how you did this? Did they already have the dll present, or did you copy it across? If the latter, did you register it?