Thread: Excel 2007,
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Excel 2007,

I am trying to run a macro that I developed in Excel 2003 in Excel 2007 that
accesses the VBA Object model. I'm also doing this on a Citrix server, and
not on my personal system.

I have done the following as described in the KB article

http://support.microsoft.com/default.aspx/kb/282830

Office Icon - Excel Options - Trust Center - Trust Center Settings -
Macro settings and selected "Trust access to the VBA Project Object Model"

All references in the workbook are available.

When I try to run the macro, I get this error:

When I run it, I get this error

Run-time error '-2147188160 (80048240)':

Programmatic access to Visual Basic Project is not trusted.

I have a feeling that part of this problem is because it's being run on
Citrix, but I'm not certain of that. Can anyone assist?

Thanks,
Barb Reinhardt