Developer Forum

I HAD CREATED ONE SPREADSHEET (SUMMARY REPORT) IN A PASSWORD PROTECTED
ENVIRONMENT THAT PULLS DATA FROM 4 OTHER WORKSHEETS THAT I ALLOWED USERS TO
INPUT DATA IN. EACH DAY AT 4:30PM SOMEONE WILL GO IN AND PRINT THAT SUMMARY
REPORT FOR THE DAY. I WANT TO BACK UP THAT REPORT, SO SOMEONE SUGGESTED ME
TO CREATED ANOTHER BOOK TO COPY AND PASTE THAT REPORT AS VALUE (NO
HYPERLINK). NO PROBLEM...BUT YOU CAN'T COPY A PROTECTED WORKSHEET. ANY HELP
OR SUGGESTIONS?

THANK YOU IN ADVANCE!!!

Stop yelling! (CAPS lock)

Change your protection settings to allow people to select cells. Then you'll
be able to copy.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Try,

Sub Sheet1Copy()
Worksheets("Sheet1").Copy
End Sub
This will copy the sheet into a new workbook, it should work with
protected sheets..