bacon
09-17-2004, 01:06 AM
Hello,
I am after a small bit of VBA to help me with a problem. I would like a message box to appear on a spreadsheet when it closes that says "Have you updated the Spreadsheet" then a Yes No option. If the user clicks Yes it will fire a Macro. If they click no the spreadsheet will close as normal.
is this simple to do?
Many thanks
Bacon
I am after a small bit of VBA to help me with a problem. I would like a message box to appear on a spreadsheet when it closes that says "Have you updated the Spreadsheet" then a Yes No option. If the user clicks Yes it will fire a Macro. If they click no the spreadsheet will close as normal.
is this simple to do?
Many thanks
Bacon