troubleshooting Question

Excel Active X control buttons in distributed excel pieces: are there downsides/ risks to Active X controls supplied by Microsoft?

Avatar of Kelvin4
Kelvin4 asked on
* ActiveXVBAMicrosoft ExcelMicrosoft Office
5 Comments1 Solution124 ViewsLast Modified:
I am considering using excel sheets and EXCEL ActiveX buttons to actuate some vba processes, instead of using UserForms.
Two reasons:
1. for catalog situations where I need one or more control buttons per data row
2. for situations where I have a child window occupying half of the excel application window (eg a child visio window) and the other half of the excel application window can display part of an excel worksheet, on which I can display data and 'buttons' to present/mimic an interactive data panel.

In both these situations, I need buttons on my worksheet.

My question is: Are Active X controls SAFE? What are there downsides? The piece is intended for many users, and potentially in web applications - so will I regret using these Active X controls down the line?
- For single 'cmd' button purposes, I can create one or more standard graphics as clickable objects through which to call macros, instead of ActiveX cmd buttons. Would you consider that positively, or are Active X cmd buttons the best choice?
- Clearly Active X provides more functionality via ComboBox/spin button/other/ controls, but are these ctls safe for distribution?

I should add that I dont envisage the excel sheet being zoomed by large amounts, incase that affects the positioning of Active X ctls?

.. looking before I leap.

NorieSenior Associate
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros