Verify that the vbe is active when using sendkeys

[PeterS]

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

 

[Guest]

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?

 

[Tom Ogilvy]

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

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?