Unprotect Sheet code runs, but doesn't unprotect sheet

[RockandGrohl]

Hi guys, having a small problem with this.

Looking to open a workbook, unprotect it and unhide hidden rows.

Set newbook = Workbooks.Open(Filename:=selectedFile, ReadOnly:=True)
DoEvents
ActiveWorkbook.Unprotect Password:="louise"
Set ss = Worksheets("Summary Sheet")

' Unhide all rows, columns & remove filters
On Error Resume Next
    If ss.AutoFilterMode Then
        ss.AutoFilterMode = False
    End If
    ss.Cells.EntireRow.Hidden = False
    ss.Cells.EntireColumn.Hidden = False
On Error GoTo 0

It can't unhide the hidden rows because the workbook stays protected, even after successfully skipping over activeworkbook.unprotect. I've also tried newbook.unprotect, and tried putting password in brackets, etc etc.

 

[RoryA]

You're unprotecting the workbook, not a worksheet.

 

[RockandGrohl]

You're unprotecting the workbook, not a worksheet.

I’ll give it a try tomorrow thanks.

 

[RockandGrohl]

You're unprotecting the workbook, not a worksheet.

ChatGPT: 0
RoryA: 143