Basically, you can setup a macro that runs whenever the file is closed.
That macro would set your data to a condition that would render the workbook
useless. Then you would have another macro that fires whenever the workbook
is opened. That macro would reset your data to what you want. HTH Otto
"N1KO" wrote in message
...
Hi,

I need (if possible) for a workbook to close if the "Disable Macro" button
is clicked when the workbook first opens.

Is this possible?

Thanks in advance

NIKO