Copy active worksheet to new workbook

Hello there,

I have been searching the internet for a macro/vba code that can do the following:

Copy active worksheet/export data, without:
- hidden rows or columns
- slicers
- hyperlinks
- formulas
- the first 12 rows

And past it to a new workbook, without changing lay-out (colours, column width etc.).

With this code, I can insert a "button" in all of my sheets in 1 excel file, so if you click on it, that specific sheet (active sheet) will open in a new workbook.

Can someone please help me?
I have been searching the internet like crazy, but none of the codes seems to work..or are too long so that my file is very slow in opening and saving.

Thank you!

Gr.,
Erika

Hi XLAdept,

Thank you !

I tried your code, it's very good, thank you. I added a few things:

Please Login or Register  to view this content.

This code deletes the slicer . But it isn't a 100% correct yet..

I noticed the following things:
- it also copies the other sheets
- it doesn't maintain the layout of a pivottable, f.e.: the title of the columnheader (of the pivottable) is in bold, but in the new workbook (copy), the columnheader isn't bold anymore
- it closes the original file with the macro, while I would like it to be still open (in the background)

Can you help me with this? I don't know much about vba, but I'm learning!

THANK YOU FOR YOUR HELP!!

Hi all,

I have a file, 'parent file', with a couple of sheets. In each sheet is a different pivottable with slicers.
The aim is to go to a specific sheet where you can choose which information you want (from the slicers). Than have an option to 'download' that specific sheet to a new file (with only hard values, and other things as listed above). This way the parent file stays intact for further use, and I can start experimenting with the info in the downloaded file.

Can you guys help me so that the code might work? I don't really know how to go further..nor do I know if my suggested code makes any sense .

Thank you!