ActiveX Control changing name in Excel when loaded on another computer

[mcava]

Hello all,

I am having trouble using a vba code I created in excel on other computers. The code contains several controls that performs calculations based on certain textbox inputs. It works flawlessly on my computer, however fails to operate when I load it on a coworkers computer.

I have played with the macro security settings on the other computer and have ensured macro and ActiveX control settings are enabled. I then thought it was how I was saving the file, however the full code is available on the other computer's visual basic. I have found that the Textboxes have changed back to their default names (ex. a textbox i have named "search" has changed back to "textbox1") which has unlinked the control to the macro. However, I can't find an explanation to why it's doing this. I have also tried to play with the control properties, but with no success.

I'm sure there is a simple solution to this, but I'm pretty new to using vba and can't seem to find a solution.

Thanks in advance and any help is appreciated!

 

[AlphaFrog]

Hi and welcome to the forum.

If this is your situation:

• ActiveX controls on a worksheet
• Saved the workbook with Excel 2007 or later as .xlsm
• Opened the workbook with Excel 2003 w\compatibility pack

Then this is a known issue and it is by design.
Files with ActiveX Controls that are saved in Office 2007 format change to images when opened in Office 2003 with the compatibility pack installed

The quick solution is to save the workbook (using Excel 2007 or later) with the .xls file format. Alternately, switch to Form-type controls.

 

[mcava]

Thanks AlphaFrog,

The other computers I'm trying to open the workbook on are also Excel 2010, so they should be compatible. Also, saving it as an .xls will disable my macros no?
If there are no other ideas I may just switch them over to form controls.

 

[RoryA]

I suspect you've fallen foul of the ongoing saga with Microsoft patches that wrecked activex controls. If you can replace them with Form controls, I suggest you do so. (I'd always use them in preference where possible anyway)

 

[AlphaFrog]

Thanks AlphaFrog,

You're welcome.

The other computers I'm trying to open the workbook on are also Excel 2010, so they should be compatible.

Yes they should.

Also, saving it as an .xls will disable my macros no?

No. The older .xls file format supports macros. Give it a try. See what happens.

If there are no other ideas I may just switch them over to form controls.

I default to using the Form controls unless I need a specific feature available only from an ActiveX control.

 

[mcava]

Thank you for the replies,

I had no success saving it in the xls. format. Is there a fast way to convert ActiveX controls to form controls? Just because I already have multiple ActiveX Textboxes made.

 

[AlphaFrog]

Is there a fast way to convert ActiveX controls to form controls?

Not that I know of.