How to break link caused by exporting sheet to a new workbook.

[bdouglas1011]

I export a sheet from one workbook to a archive file in a folder and that file is saved as .xlsx so I figured the macros would not run.

Problem is the link between the sheets allow the macro buttons to still work.

How can I break the link on export.

here is the code I use,

Please Login or Register  to view this content.

Can this be done easily?

[Greg M]

Hi there,

This is untested, but see if the highlighted addition to your code does what you need:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M