Hi Steve, I don't understand your advice. The macro workbook is sitting
read-only on a file share for multiple users to utilise, some on Excel 2003
and some on 2007 (where all these problems are happening).


"Shane Devenshire" wrote:

Hi,

Also in the security area you can designate a trusted area (folder) and then
put the file to load in there.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"GrayJayBee" wrote:

In Excel versions prior to 2007 you can create a toolbar icon and assign a
macro to it. When then clicked on it will automatically load in the workbook
containing the macro if it isn't already loaded.

In Excel 2007 the equivalent way is to create an icon in the Quick Access
Toolbar assigning the macro to it. BUT if this icon is clicked on it will
not automatically load the workbook containing the macro if it isn't already
loaded. Instead it gives an error message "Cannot run the macro 'macroname'.
The macro may not be available in this workbook or all macros may be
disabled."
THIS IS A NASTY PROBLEM.
I have a read-only workbook containing a toolset of macros that is shared
across a user base which is migrating from Office 2003 to 2007. The workbook
is in 2003 format (well, 2000 actually). Users just click on their toolbar
icon whenever they want to activate the macros, which I can centrally
maintain remotely.
How do I get this to work in Excel 2007? Is this an Excel 2007 bug?