VBA SetAttr function

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

SetAttr Function Description

The VBA SetAttr function sets the attributes of a file or directory. The SetAttr function is especially useful when wanting to hide files or make them readonly.


The syntax for the SetAttr function in VBA is:

SetAttr( path, attributes )


The path to a file or directory for which you want to change attributes. The following attributes are available for this function:

Constant Value Description
vbNormal 0 Normal (default)
vbReadOnly 1 Read-only
vbHidden 2 Hidden
vbSystem 4 System file
vbArchive 32 File has been changed since last backup
vbAlias 64 File name is an alias (Mac only)

Other Notes

The attribute can be a single value or a combination of multiple values. To combine values use the And operator or simply add the values.

Example usage

The SetAttr function can only be used in VBA code. Let’s look at some VBA SetAttr function examples:

SetAttr "C:\test.txt", vbHidden
'Result: File "test.txt" is now a Hidden file

SetAttr "C:\test.txt", vbReadOnly And vbHidden
'Result: File "test.txt" is now a ReadOnly and a Hidden file

Simply the best place to learn VBA!