p2p.wrox.com Forums - View Single Post

pgtips · #2 (**permalink**) November 6th, 2003, 05:52 AM

Here's a bit of VBS that will unprotect a worksheet:

Code:

Dim objExcel
Set objExcel = WSript.CreateObject("Excel.Application")
objExcel.Workbooks.Open "<<file name and path here>>"
objExcel.ActiveSheet.Unprotect Password:="<<password here>>"
objExcel.Workbooks(1).Save
objExcel.Workbooks.Close
Set objExcel = Nothing

hth
Phil