UserInterfaceOnly & Password Protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Tools>>Protection>>Unprotect Sheet and
start manipulating my work. Thank you.

Kind regards,

D.Parker
 
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
 
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
 
Thank you very much!!!!!!!!!

D.Parker

Paul B said:
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
Click to expand...
 
Back
Top