Log In
Register
Home
August 25, 2017
Offline
How would I go about copying one sheet to a different workbook and the macros are included with the copy?
December 5, 2016
Offline
Use macro delated all other unwanted sheets and save it new name with xlsm file type.
August 25, 2017
Offline
I don't understand your comment. I basically have one sheet that I would like to copy/transfer to another workbook that has 15+ sheets and would like to include the macro from the one sheet.
New Member
September 29, 2017
Offline
Hi mymalone.
If the macro is in the worksheet (not in a separate module) then it should get copied automatically with the worksheet. To copy the sheet manually, have both workbooks open at the same time; right-click on the tab of the sheet you want to copy, and select "Move or copy". In the dialog, select the workbook you want to copy to, and check "Create a copy".
1 Guest(s)
