Buttons lose macro assignments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have created a model in Excel 2007 using autoshapes as macro buttons.
However, sometimes when I copy, rename or move the file, the buttons lose
their macro assignment. It doesn't seem to matter when I'm using it in 2003
or 2007. Is this a bug in Excel?
 
Plum,

You say "Sometimes" so are you putting the code in the "Thisworkbook" code
module? Is the code moving with the changes that are being made?
 
Hi, yes the macro is saved in the current workbook - is that what you mean?
What happens is that when I save the file in a new location, the button does
not update to the new file name - it looks for the original file name and
tries to open up the old file.
 

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

Similar Threads

Using Autoshapes as macro buttons 4
How to call Excel add-in macro from a button… 1
Buttons re-assigned themselves to the right macro name but in Book 1
Excel 2007 macro assigned to button 3
Unable to assign macros to a new button in the current worksheet 1
Macros assigned to Menu Items 2
Button looses Macro setting when running Macro 1
Macro execution changes filename reference for all macros 1

Back
Top