Can a macro record selecting “tools” and then activation of an add-in on the “tools” menu by recording my keystrokes?
I have an add-in that is normally selected from the tools menu. I wish to select it with a macro to change some initial settings for the add-in. I have attempted to do it by “ Record New Macro” having the macro record my keystrokes. When I begin, the “stop R” box appears on my screen. I then select tools and then the add-in name at the end of the tools menu. The add-in box comes up and the “stop R” box disappears and when I view the macro later it didn’t see any of the operations starting at selection the tools menu.
I have an add-in that is normally selected from the tools menu. I wish to select it with a macro to change some initial settings for the add-in. I have attempted to do it by “ Record New Macro” having the macro record my keystrokes. When I begin, the “stop R” box appears on my screen. I then select tools and then the add-in name at the end of the tools menu. The add-in box comes up and the “stop R” box disappears and when I view the macro later it didn’t see any of the operations starting at selection the tools menu.