Is worksheet protected?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi
try
If Worksheets("Sheet1").ProtectContents Then
MsgBox "Sheet1 is protected."
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Controlling worksheet protection via VBA 0
Editing a Chart on a protected worksheet 3
Protected Worksheet Permissions 4
Macro Doesn't Work When Worksheet Protected 5
Excel VBA 0
Copying in sheet with protection with the use of a macro 5
Worksheet protection 2
Protecting Embedded Chart 1

Back
Top