vba block sheet

[max_max]

Hello
how to lock a sheet without a password

Please Login or Register  to view this content.

in this way error
max

[Squeaky]

Try
Sheets("sheet1").Select
ActiveSheet.Unprotect Password:=""
and
Sheets("sheet1").Select
ActiveSheet.Protect Password:=""
Your sheet name for "sheet1"

[max_max]

Hi,
it must work with this

Please Login or Register  to view this content.