Giordano Bruno
Well-known Member
- Joined
- Jan 7, 2007
- Messages
- 1,345
I have a workbook with code and a userform. I have code which copies some worksheets to a new workbook. The originals have a button linked to the original workbook name and procedure name. In the copied workbook, the button is linked to the new workbook and therefore does not work.
How can I ensure that the button remains linked to the original workbook so that when they are both open, the code may be run on the new workbook. Alternatively, how can I programmatically relink the buttons.
How can I ensure that the button remains linked to the original workbook so that when they are both open, the code may be run on the new workbook. Alternatively, how can I programmatically relink the buttons.