Copy Active Sheet to new workbook

[MarvinJ920]

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]

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]

Aw Hell that was easy! lol :) THANKS!

[Ken Puls]

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]

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]

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