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