Hi guys, I hope you are doing well.
Would you please assist with the below.
I’m attaching after save event to close.
However, I want to proceed with an update to ask the code to close the sheet as read-only mode.
What kind of modification I should apply here?
P.S. this post was originally posted in ozgrid but there was no solution there:
https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1204146-after-save-event
Would you please assist with the below.
I’m attaching after save event to close.
However, I want to proceed with an update to ask the code to close the sheet as read-only mode.
What kind of modification I should apply here?
Code:
[COLOR=#252C2F][FONT=Courier]Private Sub Workbook_AfterSave(ByVal Success As Boolean)
[/FONT][/COLOR]If Success Then
ThisWorkbook.Close
End If
End Sub
P.S. this post was originally posted in ozgrid but there was no solution there:
https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1204146-after-save-event
Last edited: