View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raj[_2_] Raj[_2_] is offline
external usenet poster
 
Posts: 150
Default Problem with Workbook Protection Excel 2007

Hi,

I have the following code in a module:
Sub ProtectWorkbook()
ThisWorkbook.Protect Structu=True, Windows:=False, password:="xxxx"
End Sub

When I run this, the workbook remains unprotected. I am using Excel
2007. Am I doing anything wrong?

(I tried running through the code using F8. It runs but the workbook
remains unprotected).

Thanks in advance for the help.

Regards,
Raj