Microsoft KB Archive/81567

= Excel: Duplicate NOTE or DEFINE.NAME in Recorded Macro =

PSS ID Number: 81567

Article Last Modified on 7/30/2001



This article was previously published under Q81567



SUMMARY
Duplicate NOTE or DEFINE.NAME macro functions may appear in recorded macros when only one note or name is added. This does not adversely affect the functionality of a recorded macro, but it does decrease its execution speed slightly.

To avoid this behavior while recording a macro, choose OK without choosing Add when defining a single name, or adding a single note. If you are defining more than one name or note, choose Add for all except the last note or name, then choose OK after the last one.

If duplicate functions are inadvertently recorded, just delete the duplicates.



MORE INFORMATION
The NOTE and DEFINE.NAME functions are recorded when you choose either Add or OK. This is to allow recording the definition of multiple names or notes before closing the dialog box.

Keywords: KB81567

Technology:

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2003 Microsoft Corporation. All rights reserved.