Removing the Macro Security Warning
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!) .
Using Parameters in External Data Queries
If you find yourself with data in an external database (such as Access) and are continuously editing the query there to get the data how you want it in Excel, this article will show you how such editing can be done directly in Excel. (This tutorial uses 2003, but earlier versions will be similar).