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

protect password="Mypassword"

--
Don Guillett
SalesAid Software

"Roger" wrote in message
...
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

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