On Apr 28, 11:02*am, Dave Peterson wrote:
Try using: writerespassword:="Jay"

Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", writerespassword:="Jay"

jlclyde wrote:

I have a file that I have changed the options to ask for password to
modify. *But anyone can open the file as read only. *I want to make
changes with a macro to eliminate human error. *I want the workbook to
be protected but I need the code to open the file so it can make
changes. *How is this accomplished? *I tried but this is if it has a
password to open.
Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", Password:="Jay"

Thanks in advance,
Jay

--

Dave Peterson

dave,