<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I know you can directly lock a cell/protect a sheet.<br />
<br />
But is there anyway to check if a sheet is protected via VBA? if then (yes) a specific cell is locked?<br />
<br />
Searches returned nothing relevant. Any help is appreciated!<br />
<br />
Thanks!
</div>
</div>


Hi,

I know you can directly lock a cell/protect a sheet.

But is there anyway to check if a sheet is protected via VBA? if then (yes) a specific cell is locked?

Searches returned nothing relevant. Any help is appreciated!

Thanks!

Check if sheet is protected and cell is locked

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