Hello - This is an Excel Read Only macro I have. Is there something similar to word? I'd like to shift between Read Only & Read/Write more easily than opening & closing the document.
Sub ReOpenReadOnly()
Dim Fullname As String
With ActiveWorkbook
'New file?
If .Path = "" Then Exit Sub
'Already readonly?
'Save the path\file name of the current file
Fullname = .Fullname
'Close it, ignore changes
.Close False
End With
'ReOpen readonly
Workbooks.Open Fullname, ReadOnly:=True
End Sub