Don
I am having the same problem...I used your code, but when I try to "refresh data" it gives me the error that the sheet is protected and cannot refresh. Any ideas

----- Don wrote: ----

Don't know if you solved this,bu

Sub Auto_Open(
With ThisWorkbook.Sheets("SHeet1"
.Protect UserInterfaceOnly:=Tru
End Wit
End Su

Then your macros will be able to modify everything, but the users will not, and you won't need to unlock and relock the sheet

Don