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

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

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

Thank you very much!!!!!!!!!

D.Parker

"Paul B" wrote:

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

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

Quick question on this one - how do you break this kind of protection on a
workbook?

"D.Parker" wrote:

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

Ask the developer for the password is one way.

acyakos wrote:

Quick question on this one - how do you break this kind of protection on a
workbook?

"D.Parker" wrote:

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


--

Dave Peterson