|  

» Protecting and Unprotecting Workbooks in Microsoft Excel

From the Tools menu, select Protection, Unprotect Workbook.
Type the password in the Password box, and click OK.

Unprotecting a workbook
From the Tools menu, select Protection, Unprotect Workbook.
Type the password in the Password box, and click OK.



Rate This Tip
12 34 5
Rating: 2.51     Views: 45583
Excel Protection
Taro  Posted on: 31-12-1969
I protected sheet 1. Then I copy sheet 1 to sheet 2, sheet 2 is not protected.
Anyway that if they copy to sheet 2 is still protecting.
Copy Sheet
JR  Posted on: 31-12-1969
Copy the sheet by dragging the sheet tab while pressing Ctrl.
Protection
Taro  Posted on: 31-12-1969
Thank you JR, what I want is if another people copy the sheet 1 (with proctection) and paste to sheet 2, the protection is still on.
Name
Comment Title
Comments