Notifications
Clear all
VBA & Macros
4
Posts
3
Users
0
Reactions
192
Views
Topic starter
How would I go about copying one sheet to a different workbook and the macros are included with the copy?
Posted : 30/08/2017 2:09 pm
Use macro delated all other unwanted sheets and save it new name with xlsm file type.
Posted : 06/09/2017 8:24 pm
Topic starter
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.
Posted : 07/09/2017 4:28 pm
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".
Posted : 30/09/2017 8:39 am
