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
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