Respond to a Display Alert
 

I have a file that is protected with a password required to modify. When my
macro goes to open the file I receive a dispaly alert that it is recommended
that the file is opened read only with three options to choose from; yes, no,
cancel. Yes is the default but I want the macro to select NO. How can I do
this? Please see the line of code below

Workbooks.Open Filename:=MyFile, WriteResPassword:=My_PW
--
Thank you

Dave

Respond to a Display Alert
 

Hi Dave,

Have you tried this ?

Workbooks.Open Filename:=MyFile, ReadOnly:=Yes, WriteResPassword:=My_PW




"Dave" a écrit dans le message de groupe de discussion :
...
I have a file that is protected with a password required to modify. When my
macro goes to open the file I receive a dispaly alert that it is recommended
that the file is opened read only with three options to choose from; yes, no,
cancel. Yes is the default but I want the macro to select NO. How can I do
this? Please see the line of code below

Workbooks.Open Filename:=MyFile, WriteResPassword:=My_PW
--
Thank you

Dave

Respond to a Display Alert
 

thanks, I used this to work

Workbooks.Open Filename:=MyFile, IgnoreReadOnlyRecommended:=True,
WriteResPassword:=My_PW

--
Thank you

Dave


"MichDenis" wrote:

Hi Dave,

Have you tried this ?

Workbooks.Open Filename:=MyFile, ReadOnly:=Yes, WriteResPassword:=My_PW




"Dave" a écrit dans le message de groupe de discussion :
...
I have a file that is protected with a password required to modify. When my
macro goes to open the file I receive a dispaly alert that it is recommended
that the file is opened read only with three options to choose from; yes, no,
cancel. Yes is the default but I want the macro to select NO. How can I do
this? Please see the line of code below

Workbooks.Open Filename:=MyFile, WriteResPassword:=My_PW
--
Thank you

Dave