| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
| Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
| Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
| Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Hybrid Mode
