Second chance on a save

**pprseller** · 12-01-2008, 01:09 PM

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** · 12-02-2008, 07:33 AM

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

Please Login or Register  to view this content.

**pprseller** · 09-29-2009, 01:29 PM

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

Second chance on a save

LinkBack

Thread Tools

Rate This Thread

Display

Second chance on a save

[SOLVED] Re: Second chance on a save

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions