Change file to read only

's Computer Specifications

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

's Computer Specifications

ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly

Cliff Edwards

's Computer Specifications

Thank you very much.

"ward376" wrote:

> ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
>
> Cliff Edwards
>

's Computer Specifications

You're welcome.

Cliff Edwards

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change a back up file from read only to able to save file.	diannlynnd	Microsoft Word New Users	0	31st Jul 2008 04:57 PM
Can't change .pst file from Read Only?	Ray19	Microsoft Outlook Installation	3	13th Mar 2008 05:40 PM
How do I change a file from read only	=?Utf-8?B?aGVscGxlc3M=?=	Microsoft Powerpoint	2	10th Nov 2006 04:37 PM
Change file from read only	Brent	Microsoft VB .NET	0	30th Jun 2004 02:53 PM
change read only file	=?Utf-8?B?RXJpYyBNZW5n?=	Windows XP Photos	1	16th Jan 2004 08:31 PM