Change file to read only

S

Steven

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to open file bypasses Auto_Open 4
Cannot get message box to show 1
Who opened the file 1
Change filename & auto_open 2
Code based on opening Read Only or not 4
trying to replace auto_open with something like workbook_open 1
File opens another file runs macro and closes 2
Window not active on Auto_Open 2

Top