ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trying to protect output file with Macro (https://www.excelbanter.com/excel-programming/300114-re-trying-protect-output-file-macro.html)

Vasant Nanavati

Trying to protect output file with Macro
 
Read-Only Recommended does not make the file read-only.

You need to set the WriteResPassword to make the file read-only.

--

Vasant

"dumbass" wrote in message
...
Hi-
after a user processes my spreadsheet, an output file is created which I

would like to save as a protected text-file, read-only. But somehow my macro
does not put any protection on the output file, nor is it read-only. Here is
the code:

Sheets("BranchOutputCheck").Select
ActiveWorkbook.SaveAs Filename:= _
netwrkpath2, FileFormat:=xlText, _
password:=pswd, ReadOnlyRecommended:=True, CreateBackup:=False

Thanks for the help!





All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com