Using a Macro here gains nothing, just adds another layer. I don't use macros for anything except exection of Menus. I don't agree with the suggestion of using Macros, in this case, especially because it adds nothing to the app, or in most other cases as well. VBA is much more efficient...