Is workbook / sheet protected

  • Thread starter Thread starter Tim Marsden
  • Start date Start date
T

Tim Marsden

Hi,

Is there a way (in code) to test if a workbook / sheet is protected, without
unprotecting it?

thanks
Tim
 
Hi
directly from the vBA help:
If Worksheets("Sheet1").ProtectContents = True Then
MsgBox "The contents of Sheet1 are protected."
End If
 
Hi Tim,

If you still have any concern on this issue, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
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

Excel Protection 2
Simple workbook Protect 2
Protection Problems 1
Protecting worksheet. 1
Sharing workbook removes cell protection 1
Protect / Unprotect Sheet in Share Workbook Excel 1
Problem using VBA for Excel to protect a Workbook with a password. 4
Running Macros in a Shared File 2

Back
Top