Copy worksheet in protection mode

Copy worksheet in protection mode

Post by bWw » Sat, 28 Feb 2009 01:45:03


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

Copy worksheet in protection mode

Post by THVrZSB » Sat, 28 Feb 2009 02:03:03

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

 
 
 

Copy worksheet in protection mode

Post by CurlyDav » Sat, 28 Feb 2009 22:37:35


Try,

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