Password Macro

[Don Guillett]

As always, copy/paste your code (do not attach workbook) for comments.
Generally

protect password="Mypassword"

 

[Roger]

I'm trying to write a macro that will protect a sheet and
workbook and require a password to be entered. the macro
works now, but I can not get it to require a password