Hi,

I have placed an Active X web browser control onto a worksheet in order to use it to create a scroll text effect within it using VBA.

When one opens the workbook with the standard Active X settings, the user will be warned that they have been disabled and there is a button you have to click to enable Active X controls. This would need to be done and then macro run manually to start the scroll text.

I wanted to try and have it running already when the workbook is opened so added in a line in Workbook Open() to call the macro and when I try to open it now, Excel stops responding.

It works fine with the standard settings changed to always allow Active X controls without prompting when a workbook is opened, but considering this is not the default settings, if I sent it to someone else and they opened it without changing their settings first, they would no doubt also have the same problem and Excel would stop responding.

Correct me if I am wrong but I am pretty sure is would not be possible to manipulate those settings from a VBA script, as it would defy the point of the setting existing in the first place.

However, would it be possible to somehow check with VBA that the Active X controls are not restricted before running the script that refers to them?

I am basically looking for ideas as how best to deal with this.

Many thanks