Export multiple sheets to new workbook

Hi everyone,

I'm having trouble with my VBA code.
I have about 15 sheets in my workbook, but I want to export 5 sheets to a new workbook with the click of a button and save it in the same directory as the existing workbook.
The button part is easy. I looked up something for the exporting, but it isn't working properly.
Can someone gives me some tips?
This is what I got so far, I didn't use the actual names of the sheets.

Please Login or Register  to view this content.

I'm looking forward to your awnsers!

- Daan

Hi xladept,

It works!
Just one last question. In the existing workbook there are cells with formulas. When the sheets are copied, the formulas are visible in the formula bar. Is it possible that the cells in the copied sheets only show plain text instead of the formulas?

- Daan

It works!
Thanks for your help!

- Daan