Copying Protected Worksheet

[Dummy Excel]

Hi All,
I am looking to create my own macro from an external report that I receive.
The external report is write protected so the first step that im getting the macro to do is copy the cells into a new workbook.
my code is:

    Range("A1").CurrentRegion.Copy
    Selection.Copy
    Workbooks.Add
    ActiveSheet.Paste

i get an error message saying that the workboook is write protected, unprotect first. Is there a way around this? i mean all i want to do is copy and paste!

thanks
Sam

 

[Fluff]

Do you know the password of the protected sheet?

 

[Dummy Excel]

no, no idea...the report is from one of my suppliers.
i just dont understand how you can copy and paste the data into a new workbook so you can then use all the functions of excel, although when you try and do it via a macro it doesn't allow you to