Copy worksheet in protection mode

M

ml

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!!!
 
L

Luke M

Stop yelling! (CAPS lock)

Change your protection settings to allow people to select cells. Then you'll
be able to copy.
 
C

CurlyDave

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!!!
Click to expand...
Try,

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