VBA run-time error "the specified value is out of range"

[iasiddiqui]

So i have a listbox connected to a "button" in my sheet that allows me to check off certain selections - it works great until i protect the sheet...how do i get it to run when the sheet is protected???

 

[Domenic]

Try...

worksheets("Sheet1").Unprotect Password:="YourPassword"

'Your code here
'
'
worksheets("Sheet1").Protect Password:="YourPassword"

Note, you can eliminate the password argument, if your worksheet is not password protected.

Hope this helps!