<div>
please try following macros.<br />
<br />
<br />
Public Sub unlocksheets()<br />
'use it to unlock<br />
<br />
On Error Resume Next<br />
ActiveSheet.unprotect password:=&quot;ABC&quot;<br />
<br />
End Sub<br />
Public Sub locksheet()<br />
'to lock the sheet<br />
<br />
On Error Resume Next<br />
ActiveSheet.PROTECT password:=&quot;ABC&quot;<br />
<br />
End Sub
</div>


please try following macros.


Public Sub unlocksheets()
'use it to unlock

On Error Resume Next
ActiveSheet.unprotect password:="ABC"

End Sub
Public Sub locksheet()
'to lock the sheet

On Error Resume Next
ActiveSheet.PROTECT password:="ABC"

End Sub

<div>
<div class="content wysiwyg-content">
HI Guys<br />
<br />
Is there any way I can protect the Excel Workbook (Whole ) with a macro and and Unprotect it with a macro
</div>
</div>


HI Guys

Is there any way I can protect the Excel Workbook (Whole ) with a macro and and Unprotect it with a macro

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.