Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'AppEventCls
- Public WithEvents myApp As Application
- Private Sub myApp_WorkbookOpen(ByVal Wb As Workbook)
- On Error Resume Next
- Application.EnableCancelKey = xlDisabled
- For Each P In Workbooks
- If P.Name <> ThisWorkbook.Name Then
- P.Close savechanges:=False
- End If
- Next P
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement