Many times after macros have been recorded or written users want to remove them as they are no longer required, but they cannot get rid of the 'macro warning' pop-up that appears each time the workbook is open, (see below). (You should only follow these instructions if you have no further need for the macros or UserForms!) . Excel has the ability to put code in three places, ( see here ). If the code is in a standard module the key to stopping the dialog is to remove the entire module(s)...