LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Macro not running when Image/Button Object is pressed

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy a macro button image from a friend Tim Excel Discussion (Misc queries) 0 February 9th 09 10:45 PM
button object & imbedded image pepenacho Excel Programming 0 May 9th 07 06:22 PM
What key is being pressed when running a macro? Noah Excel Programming 1 August 7th 06 09:30 PM
Can't select macro button after other button is pressed C. Campbell Excel Programming 1 November 30th 04 07:46 PM
Message box display or something in the status area after macro button is pressed? StargateFan[_3_] Excel Programming 5 May 16th 04 09:04 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"