Locking WS getting Run-time error 1004 Unable to set locked property of the range class

Hi, this code was working, then for some reason it faults out at line 90 and I am using "UserInterfaceOnly:=True". I am puzzled why it quit working. Any help is appreciated

Please Login or Register  to view this content.

I can think of a couple of things that could cause this, but without your file I don't know what did cause it.

You do not show the code that calls Protect. You may be doing UserInterfaceOnly:=True in one place but without it in another. Hard to say without seeing all of your code. You have a comment that says, "'Save the workbook after protecting" but there is no protection in sight.

If a user unprotects the sheet then reprotects it, UserInterfaceOnly:=True is no longer in force.

Thanks for the replies. Oddly this code does work, but the results isn't correct as it locks the wrong workbook, but it's doesn't fault.

Please Login or Register  to view this content.

Well that was yet another Saturday brain fart. All I had to do was unprotect, lock, then protect each sheet and it worked!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.