Got it working mostly with...
When opened in read-only mode, if someone tried to make a change, it closes without saving the changes.![]()
Private Sub Workbook_BeforeClose(cancel As Boolean) Application.DisplayAlerts = False ThisWorkbook.Save End Sub
Bookmarks