Hi
Can anyone help, is there a VBA code which i can put into an excel 2007 workbook which disables the x button on the top right hand corner and forces the user to use a macro enabled button to close.
I ask because at present i have disabled save option on close, but i want to make sure people dont accidentally close the file without saving.
Thanks for any help.
Can anyone help, is there a VBA code which i can put into an excel 2007 workbook which disables the x button on the top right hand corner and forces the user to use a macro enabled button to close.
I ask because at present i have disabled save option on close, but i want to make sure people dont accidentally close the file without saving.
Thanks for any help.