Verify that the vbe is active when using sendkeys
 

I am trying to use sendkeys. Is there a way to confirm that I have
the macro in the vbe editor, so that I have sendkeys access the vbe
editor rather than accidentally access regular excel menu?

thanks for your help

Verify that the vbe is active when using sendkeys
 

You can switch to the VBE using this

Application.VBE.ActiveCodePane.Sho

This switches to the VBE - a further refiement might be to make the 'right' code visible?

Verify that the vbe is active when using sendkeys
 

An even further refinement might be to figure out how to not have to use
sendkeys - depending on what you are doing that may be the best solution
although it is admitted that not every action can be accomplished with code.

--
Regards,
Tom Ogilvy

"AA2e72E" wrote in message
...
You can switch to the VBE using this:

Application.VBE.ActiveCodePane.Show

This switches to the VBE - a further refiement might be to make the
'right' code visible?