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