Jun 12 2011

Date Expire and Password Protect Your Excel Project

When building your Excel projects, you may want to demo a trial version of the work you have completed without giving full access to the working program. There are a couple things you can do to the project to make it difficult to access the vba code you have created. In addition to that, we’ll […]

Mar 13 2010

How to Stop Excel from Flickering during Macros

If you’ve ever written or recorded a macro in Excel, you’ve no doubt noticed that it shows everything on the screen you tell it to do. Depending on the code, Excel will show different cell locations or even different worksheets being selected during run time. Below I’m going to show you a line of VBA […]

Nov 29 2009

Macro to Disable Cell Calculations on a Sheet

If you’ve ever had a sheet in your project that has a number of formulas with calculations, you’ve no doubt noticed the slowdown that occurs when saving your spreadsheet or editing a formula.  Excel has a property that can be adjusted within a macro that allows you to turn on and off the calculations on […]

Mar 1 2009

Writing a Macro

You may have heard a macro as being referred to also as a sub or subroutine, but any way you phrase it, it is a set of instructions in VBA used to perform an action.  Using macros in Excel will greatly enhance your Excel experience and open up many possibilities through flexibility and speed.  In […]

TAGS: , ,
Nov 4 2008

Using the Status Bar to Display Messages

Excel provides an easy way to show the end user messages about the status of a macro that is running. This can be a useful way of updating users, especially during long running macros, as to the status of the routine. Some users need updates from the system to let them know that the program […]

Page 1 of 212

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks