Anything you try to do along those lines is easily defeated. Typically, all the user need do when opening the file is to not allow the macro to run. For example, if they save the opened document or workbook in the docx or xlsx format, respectively, that will kill off your macro altogether.
