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?

"Plum" wrote:

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?

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


"JRForm" wrote:

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?

"Plum" wrote:

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?