unprotect sheet via vba works first time, says incorrect password second time

[noisepoet]

I wrote the simple macro below to unprotect a worksheet. If I run it once, it works. If I run the same macro on the same worksheet a second time, I get an error: "The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization.

The workbook is .xlsb file format, with 20+ tabs, many of them hidden, and a lot of formatting (merged cells, data validation, etc.). Not sure if this is relevant, but thought I would point it out.

Sub unprotect_protect()
  
  Dim wb As Workbook
  Set wb = Workbooks.Open("C:\File Path\myDocument.xlsx")
  
  Dim ws As Worksheet
  Set ws = wb.Worksheets("My Sheet Name")
  
  Dim pw As String
  pw = "myPassword"
  
  columbiaData_Destination.Unprotect Password:=pw
 
  columbiaData_Destination.Protect Password = pw

End Sub

 

[Fluff]

You are missing the : after password on the line that's protecting the sheet.

 

[noisepoet]

You are missing the : after password on the line that's protecting the sheet.

Wow. It was that simple. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.