Macro not running when Image/Button Object is pressed

A

aeglauer

Hi everyone,

The spreadsheet in question was created using Excel 2003 and it
contains 150-some-odd sheets. I haven't even counted the macros, but
there are quite a few of those as well. On each sheet, there are
several buttons/images that each have different macros assigned to
them. Under Excel 2007, some of these images are selected when
clicked, rather than running the assigned macro. I can make these
images/buttons work again if I right-click on them and re-assign the
macro. Actually, I don't have to do anything - just bring up the
dialog box to assign the macro and choose OK, as the macro already is
assigned to the button/image. The strange thing (at least to me) is
that some of the buttons work under Excel 2007 without any
modification, while others require fixing. I haven't been able to
determine why some work and others don't - they all seem to be created
the same way.

I have set all of the security options to allow running of the macros,
and if I choose them from the ALT-F8 menu, they run without issue (I
haven't checked all of them, but the ones I have checked all work
fine).

My big issue is that there are between 1-15 (or more?) buttons on each
page, and it would be very time-consuming to go to each page and
manually "re-assign" the macros. Is there a simple way to re-assign
or re-associate the macros that are assigned to the buttons? I'm not
very fluent with VBA, so I'm unable to write something myself (and I
don't know that it's possible!).

Thanks for any suggestions!
Armand
 
A

aeglauer

I forgot to mention that if I "Convert" the file to 2007, the same
images/buttons that don't work when I open the XLS file in 2007 still
don't work in the XLSM file.

Armand
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top