Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 97 Password
- Thread starter chasb
- Start date
If you are talking about a worksheet in a workbook that is protected:<br>
<br>
Highlight the whole sheet by clicking on the upper left cornor. Press Ctl-C to copy the sheet. Insert a blank sheet if you don't already have one in the workbook. Click on cell A1 in the blank sheet. Press Ctl-V to paste the copied sheet. You should now have an unporotected version of the original sheet.<br>
<br>
Bob Crawford
<br>
Highlight the whole sheet by clicking on the upper left cornor. Press Ctl-C to copy the sheet. Insert a blank sheet if you don't already have one in the workbook. Click on cell A1 in the blank sheet. Press Ctl-V to paste the copied sheet. You should now have an unporotected version of the original sheet.<br>
<br>
Bob Crawford
- Status
Similar threads
- Locked
- Question