Change file to read only
 

I have a macro that identifies who the user is when they enter the file. Is
there a way to change a file to Read Only in the Auto_Open macro.
The sequence of events is:
User Opens file / Auto_Open macro runs / code identifies who the user is /
depending on the user Change the file to Read Only.

Thank you for you help,

Steven

Change file to read only
 

ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly

Cliff Edwards

Change file to read only
 

Thank you very much.

"ward376" wrote:

ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly

Cliff Edwards

Change file to read only
 

You're welcome.

Cliff Edwards