Forum Discussion
William Fay
Feb 22, 2018Copper Contributor
Protected worksheet
I want to open a protected worksheet and I know the password but I don't know where that can be entered. When I open the excel workbooks, I just get a blank worksheet and there is no way to input th...
JKPieterse
Feb 23, 2018Silver Contributor
On the review tab of the ribbon are buttons to (un)protect both the workbook and the active worksheet.
- William FayFeb 23, 2018Copper ContributorThanks for replying. When I click on review tab, there still is no place to put my password.
- William FayFeb 23, 2018Copper ContributorWhen I click to un protect the sheet the dialogue box stays opaque and does not allow me to click on it.
- SergeiBaklanFeb 23, 2018MVP
Do you see Protect Workbook icon at this tab? It's here.
- William FayFeb 23, 2018Copper ContributorYes I see it but after I click on it there is no place to enter my password.