Printing Macros

If you want to document your macro or perhaps study the macro code when you are away from the computer, you can print your macros. You can print the entire module sheet where your macro is stored or indicate a selection of lines to print.

To print the entire module sheet that contains your macro:

1. Place the cursor anywhere in the module sheet.

3. In the Print—VBA Project dialog box, the Current Module option button should be selected.

4. Click OK to print the module sheet. To print selected text:

1. In the module sheet, highlight the text you want to print.

3. In the Print—VBA Project dialog box, the Selection option button should be selected.

4. Click OK to print the highlighted text.

0 0

Post a comment