Capture menu selections in VBA
Hi Again,
Is it possible to capture/See if a user has selected a command from the excel menu bar and then act on the selection using VBA. This is in relation to my question about using VBA for creating comments. When I tried to record the creation of a comment the VBA code is just creating the comment, I need to capture when the comment is being created and take over using VBA to pre-fill the comment with some text and then hand back control to the user for more text input.
|