![]() |
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