ExcelBanter - Unprotect workbook?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Unprotect workbook? (https://www.excelbanter.com/new-users-excel/453888-unprotect-workbook.html)

Bob Newman[_2_]

Unprotect workbook?

Excel 2010

I have protected a workbook but see no option to unprotect it. How do I do this please?

Thanks in advance... bob

Roger Govier[_11_]

Unprotect workbook?

On Monday, 30 October 2017 20:59:37 UTC, Bob Newman wrote:
Excel 2010

I have protected a workbook but see no option to unprotect it. How do I do this please?

Thanks in advance... bob

Hi Bob
If the sheet is protected, then when you right click on the sheet tab you will see the option has changed from Protect to Unprotect.
Just click on Unprotect

All times are GMT +1. The time now is 08:13 AM.