Excel 2007,

B

Barb Reinhardt

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
 
M

Michel Petit

Hi Barb,

Try checking the:
Excel Options / Macro Settings / Trust access to the VBA project object
model.
 
V

vMike

Barb Reinhardt said:
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
Click to expand...

I am not familiar with Citrix, but have you tried adding a digital
certificate (using MS Office Tools) for yourself and then adding it to your
project.
Mike
 
B

Barb Reinhardt

I've done that before, but I don't want to add the certificate at this point.
I just got a new laptop so this may no longer be an issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007. Trust Access to VBA Project Checked, still not truste 18
"The file could not be read:" xlsMacros.txt. "Programmatic access toOffice VBA project is denied" 1
VBA code won't run, even with Macro Security set to Enable All Macors 9
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed 15
migrate xls app 2003 to 2007 -- get custom macro button out of des 3
Office 2003 macro won't run in Office 2007 2
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
Solver in Excel 2007 3

Top