Forum Discussion

PhilSmith1964's avatar
PhilSmith1964
Copper Contributor
Jan 09, 2025

Active X controls are being converted to form controls and breaking

I have built a few tools in Excel that use Active X buttons.  One department in particular is a big believer in sharing files and collaborating via One Drive, and apparently using the web version of Excel.  The problem is that I keep getting hit up by this department, to find that ALL of the Active X buttons have been converted to Form control buttons, with no code attached.  I have to delete the form controls, recreate the Active X controls, and name them what they were named originally, and the code attaches.

  1. Is this related to opening, (even briefly,) in the web version?  Or is something else going on?  I don't care if the Active X controls work on the web version, as so many other things I am using don't.  I just want them to remain Active X controls.  Any way to lock them down short of building code to recreate them every time?
  2. Regardless of the answer to 1 above, is there any way to make a spreadsheet unable to open in the browser,  Or Maybe a Group Policy to force defaults to the desktop for Chrome and Firefox?

Thanx

 

Phil

Resources