Smile. Thank you, as well !!!!

Kind regards,

D.Parker

"Dave Peterson" wrote:

Ahhhh. I get the question now...

Just to add to Paul's response:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
End With
End Sub

It needs to be reset each time you open the workbook. (excel doesn't remember
it after closing the workbook--hence the Auto_open procedure (or workbook_open
in the ThisWorkbook module.))

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

D.Parker wrote:

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

--

Dave Peterson