Buttons to run macro do not work ...
This could be because the macro that you have assigned to the button more
than likely only exists under you as a user or that the assigning itself only
exists under you as a user.
Try assigning macro to the button under a different user and give that a try!
"Joe HM" wrote:
Hello -
I have a few buttons embedded in one of my Worksheets (via
=EMBED("Forms.CommandButton.1","")). The problem is that some users
cannot press those buttons when they click on them (the Forms... does
not even show up in the fx Field). I am running Excel 2003 SP2 and the
user who opened the file has the same version. I also made sure that
the selected "Enable Macros" with the Medium Security Setting.
He can run the macro code via the Tools Macro Macros.... This is
very strange and hopefully someone here has an idea why this is
happening. The button cannot even be pressed ... just as if the Design
Mode was turned on but it is not.
Any ideas?
Thanks!
Joe
|