Password not working - SaveAs method

[tjharlan]

Hi,

Using the following code,

Workbooks("SCFA_Macro.xls").SaveAs "C:\test.xls", , , writerespassword = "nobreaks", ReadOnlyRecommended:=True

I am able to save the open workbook ("SCFA_Macro.xls) as "test.xls". I want to make the file Write-protected...and this works fine. When I close and try to reopen the newly created "test.xls" file, the password "nobreaks" does not work. I've quadruple checked such things as caps lock, spelling, etc. and cannot determine what the problem.

Any ideas?

Thanks.

 

[Glaswegian]

Hi

I think you missed the colon before your password

Workbooks("SCFA_Macro.xls").SaveAs "C:\test.xls", writerespassword:="nobreaks", ReadOnlyRecommended:=True


HTH

Regards

 

[tjharlan]

Thanks, Glaswegian.... that was the problem.

Regards,
T.J.