SVP Product Strategy

Matt Pinkston

<div>
If there is VBA code involved in the tabs that you want to protect then put this in Workbook_Open,<br />
<br />

<pre><code id="code-20-43019718-1">Private Sub Workbook_Open()
Sheets(&quot;MySheet&quot;).Protect Password:=&quot;Secret&quot;, UserInterFaceOnly:=True
End Sub</code></pre>
<br />
What <b>UserInterFaceOnly:=True</b> means is that only the user interface is locked but code may still be run for that tab.
</div>


If there is VBA code involved in the tabs that you want to protect then put this in Workbook_Open,



Private Sub Workbook_Open()
Sheets("MySheet").Protect Password:="Secret", UserInterFaceOnly:=True
End Sub


What UserInterFaceOnly:=True means is that only the user interface is locked but code may still be run for that tab.

<div>
<div class="content wysiwyg-content">
I have an excel with a bunch of tabs several of which are just displays with formulas, how can I lock down the cells of the display only tabs so you can't overwrite cells.
</div>
</div>


I have an excel with a bunch of tabs several of which are just displays with formulas, how can I lock down the cells of the display only tabs so you can't overwrite cells.

No Overwrite on Excel Cells

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

Microsoft 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.