View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Copy worksheet in protection mode

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


"ml" wrote:

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