Determine Workbook Mode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The first line in this if-statement is incorrect. What would be the correct
syntax?

If ActiveWorkbook.Mode <> xlReadOnly Then
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
End If
 
If Not ActiveWorkbook.ReadOnly Then
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
End If
 
You must log in or register to reply here.

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

ReadOnly 1
Macro to open a workbook as read only 2
Remove code from a worksheet before emailing 12
Defining the subject of an Email by value in range 5
Using a cell value as the subject line 1
Set as read only based on user name. 1
copy active worksheet plus another worksheet 1
Change File Access Question 1

Back
Top