Password protect a sheet

As in my in my heading i need to get a macro to password protect my sheet.

i have achieved this but if i change the name of the workbook or copy it and then try to unlock the sheet it dose not ask me for a password it just unlocks the sheet

any ideas ?

thank you
Wade

Post your code

ok i have attached it on note pad

That code does not apply a password to the sheet. You need to add the Password:="my password" argument to the Protect line.

OK thanks for that

so how would i inset that int to my code


ActiveWindow.SmallScroll Down:=-6
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False

Please Login or Register  to view this content.