Wouldn't it be simpler to use a password that the user doesn't know?

And don't forget to protect your project.
In the VBE:
Tools|VBAProject Properties|Protection tab

(Be aware that both the worksheet password and the VBAProject password can be
broken by anyone who's really interested.)



D.Parker wrote:

Hello:

I am using the UserInterfaceOnly to protect my worksheet. I have it placed
in the workbook object. Unfortunately, after the workbook is open the user
can ToolsProtectionUnprotect Sheet. Is there a way to password out this
option?

I would like the user to have access to only the standard toolbar, is there
a method to stop them from enabling various toolbars, menus options and
manipulating the sheet, etc.

Kind regards,

D.Parker

--

Dave Peterson