RyanScharfy
Technical User
I posted this in the Office Forum also... don't know exactly where it belongs. Sorry to double up.
I have a workbook that does the following:
I press a button and a macro (let's call it macro 1) runs manipulates a worksheet (Sheet3) and then moves it to it's own separate workbook. When it's all said and done, Sheet3 has become Sheet8.
Sheet3 has a macro saved directly to it (let's call it macro2). Sheet3 also has a radial button assigned to macro2.
When sheet3 becomes sheet8, that macro2 is still there under under sheet8. So far so good. The problem is, the radial button errors because it's looking/assigned to "sheet3.macro2" and sheet3 no longer exists/is a phantom sheet.
How can I get that button to keep pointing to macro2 in sheet8? The user needs to be able to run macro1 and not have to manually reassign the radial button to macro2.
I have a workbook that does the following:
I press a button and a macro (let's call it macro 1) runs manipulates a worksheet (Sheet3) and then moves it to it's own separate workbook. When it's all said and done, Sheet3 has become Sheet8.
Sheet3 has a macro saved directly to it (let's call it macro2). Sheet3 also has a radial button assigned to macro2.
When sheet3 becomes sheet8, that macro2 is still there under under sheet8. So far so good. The problem is, the radial button errors because it's looking/assigned to "sheet3.macro2" and sheet3 no longer exists/is a phantom sheet.
How can I get that button to keep pointing to macro2 in sheet8? The user needs to be able to run macro1 and not have to manually reassign the radial button to macro2.
