| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change file to read only
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
Cliff Edwards |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change file to read only
Thank you very much.
"ward376" wrote: ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly Cliff Edwards |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change file to read only
You're welcome.
Cliff Edwards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a file from read only back to total access? | New Users to Excel | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| Excel file change to 'read-only' when copied to another server | Excel Discussion (Misc queries) | |||
| XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
Linear Mode
