activeworkbook.unprotect password:="password"
You dropped an equal sign.
RBeau wrote:
Apologies if this gets posted twice ... could not find it listed in MSDN:
I have an application where I want to be able to run a marco that updates
data. The active workbook and sheets are protected. Looking to:
a. Unprotect the ActiveWorkbook (with password)
b. Unprotect the sheet (with password)
c. make the updates
d. protect the sheet and the activeworkbook again
I have no problem in protecting and unprotecting the sheet, but I can't get
the activeworkbook unprotected programmatically.
I used ActiveWorkbook.Unprotect Password: "password", but I keet getting a
syntax error.
According to VB help, that is the correct syntax.
Can anyone suggest a solution? Much apprectiated!
--
Dave Peterson