Using Excel 2010, window 7
I recently used the Illustration toolbar (Shapes) to create a button and then assigned a macro to it. I did so because it provides more color options, etc. This works well in the workbook and looks great. And the called macro is in the module for the worksheet. However, part of the function of the workbook is to export a few of the tabs, including the one with my button and then rename the tab accordingly. My problem is that the button on the exported file does not work. I actually have to manually reassign the macro to the button to get it to work.
Can someone please confirm whether or not this is doable and if so provide a sample of how to do this?
I recently used the Illustration toolbar (Shapes) to create a button and then assigned a macro to it. I did so because it provides more color options, etc. This works well in the workbook and looks great. And the called macro is in the module for the worksheet. However, part of the function of the workbook is to export a few of the tabs, including the one with my button and then rename the tab accordingly. My problem is that the button on the exported file does not work. I actually have to manually reassign the macro to the button to get it to work.
Can someone please confirm whether or not this is doable and if so provide a sample of how to do this?
