ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unprotect a worksheet (https://www.excelbanter.com/excel-worksheet-functions/228282-unprotect-worksheet.html)

Mayumdwl

Unprotect a worksheet
 
The file I have opened was Excel 2003 version and when I open it in Excel
2007 the sheet is protected. Can you please advice how to unprotect it?

PJFry

Unprotect a worksheet
 
On the ribbon, go to Review and then Unprotect Sheet.

Here is a great resource for using commands from a 2003 template and the
corresponding 2007 template for Excel.
http://office.microsoft.com/en-us/he...491511033.aspx
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Mayumdwl" wrote:

The file I have opened was Excel 2003 version and when I open it in Excel
2007 the sheet is protected. Can you please advice how to unprotect it?



All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com