| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy worksheet in protection mode
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!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy protection from one worksheet to another | Excel Worksheet Functions | |||
| copy in filter mode | Excel Worksheet Functions | |||
| Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
| Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
| copy in filter mode | Excel Worksheet Functions | |||
Threaded Mode
