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

Excel 2007,
 

Hi Barb,

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


"Barb Reinhardt" wrote:

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

Excel 2007,
 

That was the first thing I checked before I posted. Any other suggestions?

"Michel Petit" wrote:

Hi Barb,

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


"Barb Reinhardt" wrote:

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

Excel 2007,
 

"Barb Reinhardt" wrote in message
...
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

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

Excel 2007,
 

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.

"vMike" wrote:


"Barb Reinhardt" wrote in message
...
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

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