View Full Version : [SOLVED:] Copy Active Sheet to new workbook
MarvinJ920
12-15-2004, 12:45 PM
I have a workbook that works like a book of templates and I want one button to copy the selected sheet to a new workbook. I used record macro and I right clicked on the sheet..Move or Copy... etc to produce this result.
Sheets("Config VI").Select
Sheets("Config VI").Copy
problem is that i want the same button for every sheet. Any help would be greatly appreciated.
Thanks
Zack Barresse
12-15-2004, 12:58 PM
Hi Marvin! Welcome to the board!
Use the ActiveSheet method ...
ActiveSheet.Copy
And check out the VBA tags when posting. It will make your code look like mind. :)
MarvinJ920
12-15-2004, 01:16 PM
Aw Hell that was easy! lol :) THANKS!
Ken Puls
12-15-2004, 02:28 PM
Hi Marvin,
Welcome to VBAX! I'm going to mark you thread solved, but so you know, you can do this yourself in future by using the Thread Tools menu at the top of your thread. A very cool feature! :yes
Cheers,
Zack Barresse
12-15-2004, 02:30 PM
Aw Hell that was easy! lol :) THANKS! It usually is! For me anyway, it's usually staring me in the face (and laughing more often than not)!
Glad I could be of help!
(Hey Ken! :) )
Ken Puls
12-15-2004, 02:41 PM
Hey Zack! :)
It usually is! For me anyway, it's usually staring me in the face (and laughing more often than not)!
No kidding, me too! :yes
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.