Dave;

Thank you very much for your reply.
Regards.


"Dave Peterson" wrote:

1) Yep. It can work quicker!
2) There are commercial programs available that will break the password to
open.
3) Yep. Although, I'd save as a new name so I have both the protected version
and the unprotected versions.
4) For the workbook password and sheet password (under tools|protection), you
can identify the password--but it may not be the password that was specified.

I would think that commercial software would support all the stuff you ask.

Visit JE McGimpsey's site:
http://mcgimpsey.com/excel/removepwords.html

For lots more info.

monir wrote:

Jim;

Note that if you want to break the password on a sheet that can be done with
very simple code in about 2 minutes...

Just out of curiosity and concern, and please don't provide much details!! :
1) Can the same be done for password-protected VBAProject Properties
(protected macros) ??
1) Can the same be done for password-protected workbooks ??
2) Are these "simple" codes readily available to average users or only to
Excel Programming experts ??
3) I suppose once the password is broken, then the items are no longer
password protected for subsequent access. Correct ??
3) Can you actually identify the password in any case ??

Thank you.
Monir

"Jim Thomlinson" wrote:

I am not saying don't do it but it is a whole pile easier to password protect
the sheet than it is to effectively disable the menu item. The problem is not
with disabling the menu item. It is ensuring that you reset it appropriately.
You need to determine when the book opens, is activated, deactivated, or
closed and set the item appropriately. And all of this assumes that macros
are enabled. If they are not then you can not enable/disable the item...

If you still want to do this then you need to look at the events I listed in
ThisWorkbook and add the appropriate code to those events. Also note that the
end user could have placed a protect/unportect button directly onto one of
their toolbars so you will want/need to search through all open toolbars
looking for this button.

I personally would just add a password. Note that if you want to break the
password on a sheet that can be done with very simple code in about 2
minutes...
--
HTH...

Jim Thomlinson


"Mary Cullen" wrote:

In my VB code I want to disable the "unprotect sheet" command in
tools/protection. I am trying to avoid password protecting the sheet

--

Dave Peterson