Second chance on a save

[pprseller]

HI all, thanks for your help. I have workbook that 99% of the time I use it, print it and close it. Don't want it saved. This workbook is used by 9 other people and of course, someone saves it when they don't mean to. I need a msgbox to come up when/if they hit the "save" button on the menu bar and when/if they hit the X and prompted "do you want to save changes?" Something like a second chance to not save it - like "do you really want to save this?" I found the code to disable saves, but there are a few rare times when it does need to be saved so I can't disable all the save options. Thanks for any help.

[mudraker]

Try this - Will only work if users have macros security settings to a setting that allows macros to run

'These instructions pre typed & are worded to cater for the novice programmer

'To install macro to correct location

'Copy this macro
'GoTo Excel
'Open VB Editor by pressing Alt + F11
'Just below the menus & toolbars on the left you should see Project - VbaProject window
'In this window you will see ThisWorkbook
'double click on ThisWorkbook - opens ThisWorkbook module sheet
'Paste macro code into big window on right

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
   
   If MsgBox("Do you really want to save the workbook?", vbYesNo + vbDefaultButton2 + vbQuestion) = vbNo Then
      Cancel = True
   End If
End Sub

[pprseller]

Thank you. I should have answered and solved this earlier. I apologize for the delay. It works perfectly.