Workbook.RevisionNumber property (Excel)
Returns the number of times the workbook has been saved while open as a shared list. If the workbook is open in exclusive mode, this property returns 0 (zero). Read-only Long.
expression A variable that represents a Workbook object.
The RevisionNumber property is updated only when the local copy of the workbook is saved, not when remote copies are saved.
This example uses the revision number to determine whether the active workbook is open in exclusive mode. If it is, the example saves the workbook as a shared list.
If ActiveWorkbook.RevisionNumber = 0 Then ActiveWorkbook.SaveAs _ filename:=ActiveWorkbook.FullName, _ accessMode:=xlShared, _ conflictResolution:= _ xlOtherSessionChanges End If
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.