Excel - accessing Protected Worksheets

[Spiff59]

I've tried plugging password(s) into the Excel UDF BookOpen routine with no luck.

Is there no way to unlock a protected Excel worksheet, modify a cell or two, and then relock the worksheet?

Thanks.

[big_daddy]

You need to call the Worksheet.Unprotect Method. Then before saving call the Worksheet.Protect Method.

Edited May 20, 2008 by big_daddy

[Spiff59]

You need to call the Worksheet.Unprotect Method. Then before saving call the Worksheet.Protect Method.

Thank you, Sir!

I have another Excel question, but I guess it's best put into a seperate post.

[Shalm]

You need to call the Worksheet.Unprotect Method. Then before saving call the Worksheet.Protect Method.

I am sorry if this is a stupid question.. but how would I implement this into my script? Specifically, what would the syntax look like?

I am attempting to unprotect a sheet, make some changes, and then protect it again when done. Thanks for any help you can give!

[big_daddy]

I am sorry if this is a stupid question.. but how would I implement this into my script? Specifically, what would the syntax look like?

I am attempting to unprotect a sheet, make some changes, and then protect it again when done. Thanks for any help you can give!

#include <Excel.au3>

$sFilePath = @ScriptDir & "\Test.xls"
$sPassword = "Password"

$oExcel = _ExcelBookOpen($sFilePath)
With $oExcel.Activesheet
    .Unprotect($sPassword)
    ; Make your changes
    .Protect($sPassword)
EndWith
_ExcelBookSave($oExcel)

[Shalm]

#include <Excel.au3>

$sFilePath = @ScriptDir & "\Test.xls"
$sPassword = "Password"

$oExcel = _ExcelBookOpen($sFilePath)
With $oExcel.Activesheet
    .Unprotect($sPassword)
    ; Make your changes
    .Protect($sPassword)
EndWith
_ExcelBookSave($oExcel)

Thank you, thank you!! Now that I see it, its seems so easy.. the syntax was eluding me. Thank you again!

[symadis]

Hi ,

Thank you for this code it's working fine to unprotect the active sheet.

Can you tell me what is the good syntax for unprotect the workbook too? I think that it should be the Workbook.Unprotect Method or Workbook.UnprotectDocument but I have no idea of the syntax.

Thank you for your help

Loris

[Juvigy]

You can check the syntax on the MSDN page where you can find the Excel object model and the VBA reference.

[big_daddy]

Workbook.Unprotect Method