Hi all,
I'm fairly new to Excel VBA, and am trying to protect a workbook as much as I can.
I've been able to work my way around this VBA code (which gives the user a warning message if Excel has detected that the workbook has been copied to another location. The file then automatically closes)
So this will prevent the macro from running if the workbook is moved or copiedHTML Code:
I then have this macro:
Which will delete the workbook once it is closed.HTML Code:
What I am trying to accomplish is combining these two, so that Excel generates the pop up if the file is moved, closes itself, then deletes itself (which is where I'm trying to integrate the second macro) once it has automatically closed.
Any and all suggestions are greatly appreciated!
Bookmarks