Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Workbook_BeforeClose(Cancel As Boolean)
- On Error Resume Next
- Application.DisplayAlerts = False
- Sheets("Picking").Delete
- Sheets("Ordering").Delete
- Clear_UI
- Dim UI As Worksheet
- Set UI = Sheets("User Interface")
- With UI
- .Shapes("Menu_StartNewEvent").OnAction = ""
- .Shapes("Menu_UpdateEvent").OnAction = ""
- .Shapes("Menu_ProduceSheets").OnAction = ""
- .Shapes("Menu_CountIn").OnAction = ""
- .Shapes("Menu_EditPackages").OnAction = ""
- .Shapes("Menu_EditCocktails").OnAction = ""
- .Shapes("Menu_EditInventory").OnAction = ""
- End With
- Unhide_Them
- Set UI = Sheets("Inventory Editor")
- UI.Shapes("SaveButton").OnAction = ""
- Set UI = Sheets("Cocktail Editor")
- UI.Shapes("SaveButton").OnAction = ""
- Set UI = Sheets("Package Editor")
- UI.Shapes("SaveButton").OnAction = ""
- Hide_Them
- Application.DisplayAlerts = True
- ThisWorkbook.Save
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement