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

  • Thread starter Thread starter Stephen Fong
  • Start date Start date
S

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.
 
Stephen Fong said:
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?
Click to expand...



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
 
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.
 
Stephen Fong said:
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.
Click to expand...

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
 
Back
Top