Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Cannot run the macro 'XXX'

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to copy and paste values (columns)I have a macro file built C02C04 Excel Programming 2 May 2nd 08 01:51 PM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
Need syntax for RUNning a Word macro with an argument, called from an Excel macro Steve[_84_] Excel Programming 3 July 6th 06 07:42 PM
The macro 'xxx' can not be found Mark Heyhoe Excel Programming 0 June 15th 04 12:59 PM
Start Macro / Stop Macro / Restart Macro Pete[_13_] Excel Programming 2 November 21st 03 05:04 PM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"