how lock all of the unlocked cells in a sheet using a button on an other sheet

[ahmad1234]

after the users are done filling the input cells in the last sheet
i want them to press a button and it will lock all cells on the first sheet
please help

[AndyLitch]

To protect without a password
sheet1.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

To unprotect
sheet1.Unprotect

[ahmad1234]

thanks andylitch
but i also want to lock all the input cells on sheet1

[AndyLitch]

Ahmad

That's why it says "sheet1.Protect"

[ahmad1234]

andylitch

i want to LOCK the cells not to PROTECT the sheet
protecting the sheet without locking the cells wont do anything