<div>
To re-protect the sheets when closing place this code in the WorkBook close event<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-40853562-1"><span>Option Explicit</span>
<span></span>
<span>Private Sub Workbook_BeforeClose(Cancel As Boolean)</span>
<span> Dim ws As Worksheet</span>
<span>        For Each ws In ActiveWorkbook.Worksheets</span>
<span>        ws.Protect &quot;YourPassworsd&quot;</span>
<span>    Next ws</span>
<span></span>
<span>End Sub</span>
</code></pre>
<br />
The workbook will still have it's protection unless you remove it
</div>


<div>
<div class="content wysiwyg-content">
I would like to save time opening and closing my file and I would like to run a macro to do so.<br />
<br />
Thanks!
</div>
</div>


I would like to save time opening and closing my file and I would like to run a macro to do so.

Thanks!

How to lock/unlock a worksheet/workbook with a defined password using a macro in excel?

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