Subroutines and Functions

Tips, Tricks, and Answers

The following articles are available for the 'Subroutines and Functions' topic. Click the article's title (shown in bold) to see the associated article.

Checking if a Workbook is Already Open
Knowing of a workbook is already open can be a prerequisite to your macro working correctly. Here's how to check it out.

Deleting Worksheet Code in a Macro
If you are writing some complex macros, you may want those macros to actually delete VBA procedures associated with different worksheets in your workbook. You can do the deletion by following the advice provided in this tip.

Disabling a Function Key
Function keys are used to perform common tasks in Excel. If you want to disable one of the function keys, it's rather easy to do. Here's how to do it.

Displaying the Print Dialog Box in a Macro
Want to print a document by using a macro? One way is to display the Print dialog box and allow the user to interact with it. This tip demonstrates how easy it is to actually pull up the desired dialog box.

Progression Indicator in a Macro
If you use macros to process data in a workbook, it can often appear like the macro is doing nothing, even though it is working hard behind the scenes. This is the time when you need some sort of indicator on-screen to let users know that the macro is, indeed, working away.

Turning Off Screen Updating
Your Excel macros may be a bit slow if they do a lot of changes to data in your worksheets. You an significantly speed up the macros by adding just a couple of lines of code in order to turn off screen updating.

Understanding Subroutines
When developing macros, you can create subroutines. This is a great way to reuse common code and make your programming tasks easier.

Using a Progress Indicator in Macros
A few tips on adding a progress indicator that runs during long macro calculations.