I have a file with a nice workbook_beforeclose sub in it. In this sub some cells are checked for their contents and if the contents is not correct the sheet will not close.
However, I want to insert a button with which people can exit the sheet anyways.
Now I have a activeworkbook.close statement behind this button but then ofcourse the workbookbefore_close sub stops the file from being closed.
Can I somehow program the button to skip the workbook_beforeclose sub?
thnks, I hope someone can help me.
However, I want to insert a button with which people can exit the sheet anyways.
Now I have a activeworkbook.close statement behind this button but then ofcourse the workbookbefore_close sub stops the file from being closed.
Can I somehow program the button to skip the workbook_beforeclose sub?
thnks, I hope someone can help me.