| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ReadOnly
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
This will ask me if I want to save the file first. I tried DisplayAlerts = False but that caused an automatic save before changing to ReadOnly. Is there a way to not Display the Alert and have it change to ReadOnly without saving. Thank you, Steven |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ReadOnly
I haven't tried it. but try doing
Activeworkbook.Saved = True Activeworkbook.ChangeFileAccess Mode:=xlReadOnly -- Regards, Tom Ogilvy "Steven" wrote: ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly This will ask me if I want to save the file first. I tried DisplayAlerts = False but that caused an automatic save before changing to ReadOnly. Is there a way to not Display the Alert and have it change to ReadOnly without saving. Thank you, Steven |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ReadOnly = NO | Excel Programming | |||
| Can .xls make itself ReadOnly? | Excel Programming | |||
| Readonly files | Excel Discussion (Misc queries) | |||
| Readonly | Excel Programming | |||
| Open As Readonly | Excel Programming | |||
Linear Mode
