Thread: Verify that the vbe is active when using sendkeys
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E[_2_] AA2e72E[_2_] is offline
external usenet poster
  
Posts: 93
Default 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?
Reply With QuoteReply With Quote