Workbookclose function

[Mick Butler]

Hi,
I have a spreadsheet used by several users. I want to make sure that if they make any changes, they use the File=>Save As option and and increment the version number in the file name. In order to prompt this, I pictured a dialog box similar to the one that says "Do you want to save changes" that appears on Exit?

I'm assuming I need a macro but being a Macro virgin, I'm a bit stumped where to begin.

OK - the details. If the user clicks File=>Exit, or the Top RH Corner X, I want a dialog box thats says "If you have modified this file, please ensure that you use File=>Save As option, and save as a higher version" I then picture the user having two buttons: "Return to Excel" (which cancels the Exit procedure and returns the user back to the workbook) and "Continue to Exit" (which allows the exit procedure to continue)

For info, I'm on Excel 2003 SP3 running on XP Professional 5.1.2600 Service PAck 2.0

Any help or advice gratefully received

[royUK]

it's not difficult, but how can yo ensure that the user adds a correct number? Maybe build it from a combination of date & time

[Mick Butler]

Thanks RoyUK,
You're right, I can't be sure that the user will use the correct number. And yep, I could automate it to some extent, however, the point is that once prompted, the user will ast least make a conscious decision as to whether it's needed.
Where I'm struggling is with the macro. I've rarely used macro's and just don't know where to start

Thanks


Mick