D, something like this, but worksheet passwords are very easy to break

Worksheets("sheet1").Protect password:="test", userInterfaceOnly:=True
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"D.Parker" wrote in message
...
Hello. I am reposting my question, asking it a different way. Is there a
way to use the UserInterfaceOnly in conjunction "with" a password? Such
that
the user of the workbook cannot go to ToolsProtectionUnprotect Sheet
and
start manipulating my work. Thank you.

Kind regards,

D.Parker