ReadOnly

S

Steven

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
 
T

Tom Ogilvy

I haven't tried it. but try doing

Activeworkbook.Saved = True
Activeworkbook.ChangeFileAccess Mode:=xlReadOnly
 

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 a workbook as read only 2
ChangeFileAccess 1
Reference issues in Excel 2003 2
XL03: Avoid "workbook contains links" msg when opening 6
Open file ready only 2
Cannot save macro spreadsheet due to ReadOnly = True 1
Workbooks.Open using Dialog box 1
ReadOnly = NO 2

Top