Cimaware Software
Expert Zone
-Nick Hodge
Nick Hodge has been a Microsoft MVP for Excel since 1999. His experience in Excel dates back to Excel V5.
Nick comes from near Southampton in the United Kingdom and makes his living outside of the industry, running the UK division of Burnsville, MN based Northern Tool + Equipment. His main interests in Excel cover Pivot Tables, External Data and VBA.
Nick Hodge’s Excel site on the user interface of Excel, how to control it through VBA and several Tips and Tricks.
Author website: www.nickhodge.co.uk
-
Removing the Macro Security Warning | Expert Zone
2006-05-10 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 | Expert Zone
2006-01-11 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).