activex error when opening the workbook - how to stop it...

[Chrissirhc]

Hi,

When we open a workbook in Excel we get the error

"this application is about to initialize Active controls that might be unsafe. If you trust the source of this file, select OK and the controls will be initialized using your current workspace settings"

I am aware of this Microsoft thread

http://support.microsoft.com/default.aspx?scid=kb;en-us;827742

Is there a way to find out what control is causing this error?

Thanks in advance,

Chris

 

[firefytr]

Hi there,

These would be active ActiveX controls. It doesn't really matter what kind or how many controls you have, the registry hack is about the only way around it. It's either find another way around using the controls, or adjust your registry. It's extremely give and take here.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[Chrissirhc]

How do you know which ones in your sheet are activex ones?

 

[KenPuls]

Go in to the workbook, and right click your controls.

-If it comes up with a right click menu that shows the "Assign Macro" command, (near the bottom,) it is NOT and ActiveX control, it is a Forms control.

-If it comes up with a right click menu that shows the "Properties" and "View Code" commands (in the middle), then it IS and ActiveX control, and you ARE in "Design Mode" to edit them.

-If it won't come up with anything, then it is an ActiveX control, and you are NOT in "Design Mode". You can activate design mode by opening the Control Toolbox toolbar, and clicking on the first icon that looks like a triangle.

HTH,


Ken Puls, CMA

http://www.excelguru.ca

 

[firefytr]

On the Visual Basic toolbar there is a button called Design Mode (looks like pencil, ruler, protractor). Click that and when your right click your objects if you see Properties, it's ActiveX. That's probably one of the fastest ways.

If you right click an object and you don't see Properties, but you see Assign Macro, it's a Forms object (part of the Shapes collection).

If you don't know where they are, you can use

http://www.asap-utilities.com

addin to select all objects on a sheet, which may be a little more helpful in locating them.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci