"Programmatic Access to be Denied" displays when running macro on excel in XP

[Stephen Fong]

Please help me that I had wroten a macro in excel file.
When the macro run on the Windows 2000 platform, it has
not any error. But when it run on Windows XP platform,
the message box will be displayed "Programmatic Access to
be Denied" and need to click the "continue" button to
continue to run the program.

How can I set the option to omit this alert box in excel
when running the macro in Windows XP?

Thanks a lot.

Best Regards,
Stephen Fong.

 

[Keith Willshaw]

Please help me that I had wroten a macro in excel file.
When the macro run on the Windows 2000 platform, it has
not any error. But when it run on Windows XP platform,
the message box will be displayed "Programmatic Access to
be Denied" and need to click the "continue" button to
continue to run the program.

How can I set the option to omit this alert box in excel
when running the macro in Windows XP?

You need to go in to Excel in XP and

1) On the Tools menu, click Macro, and then click Security to open the Macro
Security dialog box.

2) On the Trusted Sources tab, click to select the Trust access to Visual
Basic Project check box to turn on access.

3) Click OK to apply the setting. You may need to restart the application
for the code to run properly if you automate from a Component Object Model
(COM) add-in or template.

Keith

 

[Stephen Fong]

Hi Keith,

I had try to set the setting in Excel but it still doesn't
work. Does it miss any COM add-in in the program that is
different in Windows 2000? Please advise. Thanks.

Best Regards,
Stephen Fong.

 

[Keith Willshaw]

Hi Keith,

I had try to set the setting in Excel but it still doesn't
work. Does it miss any COM add-in in the program that is
different in Windows 2000? Please advise. Thanks.

Best Regards,
Stephen Fong.

Not as far as I know. I got that problem when trying to
manipulate the VBA in the Excel 2002 worksheet
from a VB6 program. There's a separate security tab
to trus com add-ins.

Keith