ActiveX Controls Warning Message

Peter Rattigan

Board Regular
Joined
Oct 18, 2004
Messages
77
I am building an application that uses Access2k as the frontend to collect a range of data then exports that to Excel using "transferspreadsheet".

In Excel I use a userform (tabbed control)to display the results with graphs etc. On one of the tabbed pages I have used a MS Office Spreadsheet Control 9.0 to display a formatted spreadsheet which loads each time the Workbook is opened. In Office 2000 this worked beautifully.

I then loaded the application on an Office 2003 PC and the fun starts. First. I find that the Spreadsheet contol is not there anymore and causes a code break. I searched through the Contol Toolbox Add-ins and can't find any reference to a MS Office Spreadsheet Control 9.0, just 10.0 and 11.0. So I add the 10.0 and run the code and the spreadsheet is loaded with data but does not mirror the formatting of the spreadsheet is is copying.

I need to make this application work on any machine I load onto but if the 10.0 or 11.0 dont format the same then it is not a good alternative.
Is there a an automatic way to add 9.0 to Office 2003 PC's? :confused:

The second problem on the 2003 system is that when the the code starts running on the workbook-Open event it now generates a message saying " This Application is about to initialize Active X controls that might be unsafe, do you wish to continue". I need to turn this off but can only find a reference on the MS site (Article ID 827742) to amending registry keys to stop it. Lowering security settings doesn't help. Is any one aware of a way of turning this off that can be automated for install on other PC's.

Thanks for any suggestions.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

AgentSmith

Well-known Member
Joined
Mar 8, 2004
Messages
575
Actually I've just had a go at inserting that control in a dummy spreadsheet - it worked fine and I use XL2003 too. I had version 10.0 and 11.0 available too. It sounds like your computer doesn't have this component installed on it (or it's not registered properly). One for the IT help desk, methinks!
 

Peter Rattigan

Board Regular
Joined
Oct 18, 2004
Messages
77
Thanks

Thanks for your reply Smithie. I'll have a look and see why control 9.0 isn't appearing.

Cheers
 

stucamps

Board Regular
Joined
Jul 3, 2003
Messages
114

ADVERTISEMENT

The second problem on the 2003 system is that when the the code starts running on the workbook-Open event it now generates a message saying " This Application is about to initialize Active X controls that might be unsafe, do you wish to continue".

I am getting this message when trying to open a spreadsheet from another spreadsheet - is there a way to turn this off in my VBA code?
I am trying to use
Application.DisplayAlerts=False

But this doesnt work.
Any advice?
Thanks
Stuart
 

Peter Rattigan

Board Regular
Joined
Oct 18, 2004
Messages
77
Hi Stu

I ended up getting around this problem by going to the microsoft site using the error message as a search in google. MS have a fix that involves changing some registry keys. I was dabbling in an area that I didn't understand so I obtained some help from the local IT guru to do the changes and it worked. Good luck
 

babs

Board Regular
Joined
Oct 30, 2002
Messages
106

ADVERTISEMENT

Peter,

it will be a great help for everyone, if you post the link as well.
 

Peter Rattigan

Board Regular
Joined
Oct 18, 2004
Messages
77
The following script changes the registry keys to make the active X control warning message go away. I have used it on quite a few PC's now and it works well. It just needs to be included in a folder and the file name extension changed to .REG. Double clicking the resultant Icon will install the fix. Hope this helps.

Code:
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Common\Security]
"UFIControls"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\Common\Security]
"UFIControls"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\VBA\Security]
"LoadControlsInForms"=dword:00000001
 

Watch MrExcel Video

Forum statistics

Threads
1,118,824
Messages
5,574,525
Members
412,601
Latest member
TheBeaniacExpress
Top