Copy protected sheet to a NEW workbook that is not protected

Let me preface this by saying I've been searching over two hours on what I thought would be a simple macro to find.
I have a master data sheet in one workbook that, when the user clicks the button, it will copy that sheet into an automatically created workbook where the user can do as they please with the data. The data in the original workbook is protected and I'd like this protection to go away in the new workbook preferably without having to enter the password.
I'm decent with manipulating code to suit my needs but I dont know jack about vba syntax.
Thank you for assitance in this relatively easy macro.

- Luke

Which part are you stuck with the copying or protection?

Please Login or Register  to view this content.

Selecting and copying a sheet is easy enough. I'm having trouble with creating a new workbook and pasting the specific sheet into it. I thought it would be simple, but I've looked at a ton of code, none of which is the same, and all of which had different errors for me. I have a feeling that its only a few lines of basic code. I havent looked into the password protect issue yet, I just thought of that when I typed the post. Thanks.

- Luke

Please Login or Register  to view this content.