<div>
Hi keilah,<br />
<br />
It sounds like you are trying to do some advanced protection, and the fact is that no protection is going to stand up more than 2 minutes to anyone who really wants to get in the file - excel protection just isn't that robust and there are too many tools out there to crack excel passwords.<br />
<br />
The normal code for excel protection is:<br />
<br />
Sheet:<br />
Sheets(&quot;mySheet&quot;).Protect &quot;myPassword&quot;<br />
<br />
Workbook:<br />
Workbook(&quot;myWorkbook&quot;).Sav<wbr />eAs Workbook(&quot;myWorkbook&quot;).Ful<wbr />lName, , &quot;myPassword&quot;<br />
<br />
These don't however include the functionality to lock someone out after 5 tries, and I don't believe that there is going to be a simple way to implement this in Excel.<br />
<br />
Cheers,<br />
MalicUK.
</div>


Hi keilah,

It sounds like you are trying to do some advanced protection, and the fact is that no protection is going to stand up more than 2 minutes to anyone who really wants to get in the file - excel protection just isn't that robust and there are too many tools out there to crack excel passwords.

The normal code for excel protection is:

Sheet:
Sheets("mySheet").Protect "myPassword"

Workbook:
Workbook("myWorkbook").SaveAs Workbook("myWorkbook").FullName, , "myPassword"

These don't however include the functionality to lock someone out after 5 tries, and I don't believe that there is going to be a simple way to implement this in Excel.

Cheers,
MalicUK.

<div>
PS.<br />
SerialShield SDK may also prove useful:<br />
[ <a href="http://www.ionworx.com/serialshield.html" rel="ugc">http://www.ionworx.com/serialshield.html</a>&nbsp;]<br />
<br />
<br />
Please let me/us know what option you go for.<br />
<br />
Thanks.<br />
<br />
BFN,<br />
<br />
fp.
</div>


PS.
SerialShield SDK may also prove useful:
[ http://www.ionworx.com/serialshield.html [http://www.ionworx.com/serialshield.html] ]


Please let me/us know what option you go for.

Thanks.

BFN,

fp.

<div>
<div class="content wysiwyg-content">
Hi Developers need a vba code to password protect a workbook and work sheet in the work book. 5 attemps at the code before locking out. <br />
<br />
Same password for workbook and worksheets.......<br />
<br />
thanks...........
</div>
</div>


Hi Developers need a vba code to password protect a workbook and work sheet in the work book. 5 attemps at the code before locking out. 

Same password for workbook and worksheets.......

thanks...........

Password Protect Workbook and worksheet - Allow Five Attemps

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.