Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am developing an Excel 2007 add-in compromising of an Excel Add-In (.xla
file) and a COM Add-In (managed code written in C# in Visual Studio Tools For Office). In the start-up function of the COM Add-In I need to call a macro on the .xla file. In the installer application for the add-in I am changing the registry keys in Excel Security so that: - The Trust access to VBA project object model check box is ticked; - All macros are enabled. On a large proportion of computers that I test the add-in on, everything works fine. However there are a few computers which (when attempting to run the macro) fails with the following error: "Cannot run the macro 'XXXXX'. The macro may not be available in this workbook or all macros may be disabled." I assume that there must be some further configuation in Excel 2007 to allow the macro to be run. Any help in pointing me in the right direction would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
The macro 'xxx' can not be found | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |