I built a workbook in Excel on my old machine that has a bunch of UserForms in it. One of the UserForms has an ActiveX spreadsheet control in it. This allows me to enter spreadsheet data into the UserForm. My old computer recently crashed so my IT department gave me a new machine that is running the same system (Microsoft Office 2010). Now, when I open the spreadsheet, I get:
Could not load some objects because they are not available on this machine.
I Googled this error and read through a number of pages. The first thing to try was installing Microsoft Office Web Components 11.0. Weirdly, this allows me to add a spreadsheet control to any UserForm I want to but I still cannot open the original sheet with all of its controls still in it.
Next, I tried these instructions but got no results.
Does anybody have any ideas?