View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default 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