Re: VBcomponent: Remove Before Close
Hi, I posted the original thread a long long time ago, but still have not resolved the issue. The current workaround that I have is to have the user re-save the document after the code has been executed because as soon as control is passed back to the user the delete commands are actually executed. Unfortunately I already have EnableEvents to false, is there anything else out of the ordinary that you did to get it to work? A summary of what my code does: it creates a copy of the workbook (in an extremely horrible way), then executes the delete code commands, and then if I try to save that new workbook with the code deleted out of it it just saves it as if the code hadn't been deleted. Thanks.