| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox - Output results to a csv file | Excel Worksheet Functions | |||
| output to the same line in a Text file? | Excel Discussion (Misc queries) | |||
| Need Help With Loop That Creates Output File | Excel Discussion (Misc queries) | |||
| Open a print output sent to file | Excel Discussion (Misc queries) | |||
| how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
Threaded Mode
