I've seen this before. I assume you users have Office 2007. In that
version, if your code is run from a click event rather than being run
directly by excel based on the value of the OnAction property of the button,
you need to set the Cancel paramter to true even though the button is not a
built-in feature of Excel.

" wrote:

hi,
if the user can run the macro from the menu, that (to me)
zeros in on the form.
the file name appearing in front of the macro name
indicate that the macro is not in the active file. at
least on my pc. if i have 2 files open both with macros,
the macro box shows only the macro name of the macros in
the active file but show both file and macro names of the
inactive file.
i am still on 2k so i not sure how squirlly 2002 and 2003
is.

-----Original Message-----
This has me stumped, so any help will be deeply
appreciated!

I built a form that creates a custom toolbar when the
file opens to allow
the user to run macros. Recently several new users have
reported a series of
errors when they click any of the custom buttons. I
can't reproduce it on my
computer but the errors sound like the buttons are trying
to run the macros
from a different workbook that doesn't exist. The users
are prompted to
"Enable Macros" a second time and then get a message that
the macro can't be
found. The users can, however, run the macro directly
from the menu options,
just not from the custom buttons.

When I open the Assign Macro box, I see the current file
name as a path in
front of the macro name. Could that be causing the
problem? I remember,
sometime in the past, seeing only the macro name (no file
name) in the Assign
Macro box.

I've used either Excel 2003 or Excel 2002 to edit the
file, depending on
which office I'm working in. I've tried setting the
macro assignment to
"This Workbook only", but the file name is still there.
On my computer(s),
the file name does change when I rename the file, so the
buttons still find
the right macro to run.

I haven't pinned down a common attribute for the all
users who have this
error, but several work on US Government sites which have
many security
restrictions on software. Is it possible that network
security is affecting
the connection between the button and the macro?

Any ideas?

Thanks,
EllenR
.