Hi all,
I have made a Daily log (workbook) with a worksheet as a handover sheet for work. There is vba code that copies the Handover worksheet from the current shift to the oncoming's shifts log (workbook) and saves the oncoming Daily Log and closes it. This all works great. I have made a couple of macros within the Handover sheet but when it copies on to the oncoming shifts workbook (daily log) the macros do not work. The code is there but you have to reapply the macro to the button. Is there any way around this?
Thanks all
I have made a Daily log (workbook) with a worksheet as a handover sheet for work. There is vba code that copies the Handover worksheet from the current shift to the oncoming's shifts log (workbook) and saves the oncoming Daily Log and closes it. This all works great. I have made a couple of macros within the Handover sheet but when it copies on to the oncoming shifts workbook (daily log) the macros do not work. The code is there but you have to reapply the macro to the button. Is there any way around this?
Thanks all