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

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?

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?