Active x Control - stumped

chef

Well-known Member
Joined
Jul 10, 2002
Messages
561
Office Version
  1. 365
  2. 2016
Hi
Am stumped and wondering if simple solution i'm missing

I used an active x list box and use on spreadsheet fine and so does my colleague.
When I shared via network and 3 other colleagues in another dept tried to use it does not work or change figures when option buttons used on list.

I have made sure they have macros enabled on their machines but still nothing?

They have office 2007 but im thinking there is no funtionality that cant be used if made in higher versions? like 2016 as its just a simple list box. with buttons against names....../macros enabled and formula used when list box chosen

can anyone shed any light on why this might be an issue and any resolution would be great
regards
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,488
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Do you need to use an activex one rather than a Form control? Activex controls are prone to problems like this (e.g. when different machines have different versions of the MSForms library, the controls won't work at all on one of the machines)
 

chef

Well-known Member
Joined
Jul 10, 2002
Messages
561
Office Version
  1. 365
  2. 2016
Thanks for the quick reply Rory and you are right, I dont really need to use active x and I have changed to a drop down combo and think will leave them well alone given what you have said as this could be published on literally hundreds of different machines, makes models of PC/Laptop and I had not realised this would be an issue.

Appreciate you getting back so quick and with a resolution as to why I should not use them..

regards
 

Watch MrExcel Video

Forum statistics

Threads
1,127,881
Messages
5,627,447
Members
416,248
Latest member
inese_green

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top