Question: how to copy an excel sheet with macros?
Answer: Open the workbook that has the macro you want to copy. Press the "Alt" and "F11" keys together to access the VBE. Click on the name of the macro you want to copy in the left-hand column. ...  Click on the "Edit" tab and then click on "Select All." Click on "Ctrl" and "C" to copy the macro to the Office Clipboard.