I have been using a button that I placed on a worksheet months ago that I use
to run a macro which generates graphs from data and places them into the
workbook. I then move the graph sheets to another workbook and rename the
workbook. Suddenly today every time I try to run the macro after moving the
worksheets to another book the buttons macro assignment changes to the newly
created workbook and the name of the macro I have been using. And of course
there is no macros in this workbook so it does not run. I have rebooted,
assigned the macro correctly and saved the worksheet and it still changes the
buttons assignment. What in the world is going on here? This workbook that
the button is in was made in Excel2000 and then resaved in 2007 months ago.
It appears to run in 'compatability mode'. Why is it suddenly doing this
after 6 months of working perfectly? And how can I stop it?