Buttons to run macro do not work ...

  • Thread starter Thread starter Joe HM
  • Start date Start date
J

Joe HM

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
 
Hmmm.... I don't know for sure what's going on, but you want to find out
which kind of button you have on your worksheet and where the associated
macro code really is located.

As you know, the button can be built with the Forms toolbar or from the
Control Toolbox. The button you describe as "embedded" suggests that it was
built from the Control Toolbox. However, macro code for these buttons is
Private and is not accessible through the Tools, Macro, Marcros menu. You
have to right-click on the button in DesignMode, choose ViewCode, and build
the code there.

The symptom you describe can occur on a protected worksheet, but only when
design mode is on (and you've confirmed that it's off).
 
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!
 
Hello -

Yep ... I inserted the button via the Control Toolbox and everything is
working fine for 30-40 different users. There is only one user who has
that problem. Maybe he should just re-install Excel? I know ... this
is really strange ...

Thanks!
Joe
 
Back
Top