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