Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unprotecting (with password) the activeworkbook
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotecting sheet did not prompt for password | Excel Programming | |||
Macro asking for a password twice when unprotecting sheet | Excel Programming | |||
Password Protecting/Unprotecting Via Code | Excel Programming | |||
Unprotecting password protected workbook | Excel Discussion (Misc queries) | |||
Simple password function - unprotecting sheets | Excel Programming |