Hi,
one way:

Application.VBE.CommandBars.FindControl(ID:=106).E xecute
Sheet1.Activate

i suppose 'Alt-F11' would be enough usually.

--
HTH,
okaizawa

helmekki wrote:
Hi there

Is there a way in Excel VBA to change focus from a VBA window to
sheet1, programmically?? I want to be able to see the VBA window while
being able to type into sheet1 of Excel