<div>
I don't understand - you will still have to protect the worksheet!
</div>


I don't understand - you will still have to protect the worksheet!

<div>
I plan on protecting the worksheet to allow input on specific &quot;unlocked&quot; cells. I do not want anyone to unprotect it and passwording can be an issue.
</div>


I plan on protecting the worksheet to allow input on specific "unlocked" cells. I do not want anyone to unprotect it and passwording can be an issue.

<div>
And you're going to protect the code that does this by........?
</div>


And you're going to protect the code that does this by........?

<div>
Bear in mind that they can also customise their toolbar and drag a new 'Unprotect sheet...' control onto it.
</div>


Bear in mind that they can also customise their toolbar and drag a new 'Unprotect sheet...' control onto it.

<div>
Thanks for sharing your concerns. My goal here is to &quot;Strongly&quot; discourage people from changing anyhting on the spreadsheet. The problem that I run into with passwords is that they can be changed without my knowledge and then I have a real problem. This ia an attempt at protection without a password.
</div>


Thanks for sharing your concerns. My goal here is to "Strongly" discourage people from changing anyhting on the spreadsheet. The problem that I run into with passwords is that they can be changed without my knowledge and then I have a real problem. This ia an attempt at protection without a password.

<div>
<div class="content wysiwyg-content">
I have a spreadsheet that I do NOT want anyone to change. Rather than protecting it with a password I would like to disable the &quot;Unprotect&quot; option in the menu bar. Is this possible using VBA code?
</div>
</div>


I have a spreadsheet that I do NOT want anyone to change. Rather than protecting it with a password I would like to disable the "Unprotect" option in the menu bar. Is this possible using VBA code?

Help Disabling the &quot;Unprotect&quot; option in the menu bar of Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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

Help Disabling the &quot;Unprotect&quot; option in the menu bar of Excel

Help Disabling the "Unprotect" option in the menu bar of Excel