Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"lothario" wrote in message
... Hi, I would like to ensure that after the file is saved, the attributes of the file are changed such that: 1. It becomes READ-ONLY. 2. It cannot be deleted. Please show me the VBA code that I can incorporate to the above to accomplish this. Thanks, Luther Does this help? This example uses the SetAttr statement to set attributes for a file. SetAttr "TESTFILE", vbHidden ' Set hidden attribute. SetAttr "TESTFILE", vbHidden + vbReadOnly ' Set hidden and read-only ' attributes. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protecting a file from Copy/Paste | Excel Discussion (Misc queries) | |||
Protecting an Excel file | Excel Discussion (Misc queries) | |||
Protecting a file in Excel 2003 | Excel Discussion (Misc queries) | |||
Protecting Excel file to prevent changes | Excel Discussion (Misc queries) | |||
protecting a file from deletion | Excel Discussion (Misc queries) |