Search Commands Finds Functions Fast in Microsoft Office

When you cannot find a function on the 2007 ribbon this could come in handy:

Search Commands Finds Functions Fast in Microsoft Office

Spreadsheets: Protecting All Worksheets

This is a great article from Bill Jelen - CFO.com on using VBA to protect all sheets within a workbook:

Spreadsheets: Protecting All Worksheets

Visual Basic User's Guide

For programming in VBA script for Excel, this is a very inexpensive guide to help you get started:

Visual Basic User's Guide: Microsoft Excel Version 5.0: Automating Customizing and Programming in Microsoft Excel with the Microsoft Visual Basic Programming System Applications Edition

Speeding up your macros with VBA script

Removing auto-calc – You can switch off auto calculations in Excel manually by switching your calculation options to manual (found under tools menu in Excel 1997).  Another strategy would be to switch this off within your code through the command Application.Calculation = xlCalculationManual.  Be sure to include the command Application.Calculation = xlCalculationAutomatic at the end of your code to avoid user confusion when the calculations do not perform after the script is run.  When testing you need to remember this will switch to manual calculations will remain in affect long after you have finished your testing.

Removing refresh – Excel is constantly refreshing your screen.  When running a macro, it is not necessary to display your results after each step that is taken.  Every second that Excel attempts to refresh your screen to show your latest results is a second taken away from processing your script.  To remove this anchor you will need to switch this off through the command Application.ScreenUpdating = False and switch it back on at the end of your code with the command Application.ScreenUpdating = True.

Declaring Variables - When using scripts that contain variables such as for I = 1 to 100 you can improve your speed by declaring that variable first.  Declaring I as an integer will tell your computer what to expect when it encounters this variable I and wont reserve too much memory by treating it as a potential 256 character variable.

VBA/Excel Connecting Excel to Access using VBA

This is a good Youtube demonstration on pulling data from an Access database into Excel with just a few short steps in VBA: