Register
Log In
Unanswered
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".
Most Users Ever Online: 57
Currently Online:
12 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Mohamed Rehan Memon
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
