Click inside both Spreadsheet and VBE - Back and forth
 

Can you set things up so that both
the Spreadsheet and the related VBE
can share the screen *PLUS* allow you
to (with one click) jump from one -to
the other; I'm tired on when I click
on my Spreadsheet to enter something
the VBE minimizes and I have to go back
and bring it back up in order to see any action
that takes place on both..

Click inside both Spreadsheet and VBE - Back and forth
 

Resize both windows to fit side by each.

That is......the VBE main window and the Excel main window.


Gord Dibben MS Excel MVP

On Sun, 4 Mar 2007 18:15:56 +0000, "JMay" wrote:

Can you set things up so that both
the Spreadsheet and the related VBE
can share the screen *PLUS* allow you
to (with one click) jump from one -to
the other; I'm tired on when I click
on my Spreadsheet to enter something
the VBE minimizes and I have to go back
and bring it back up in order to see any action
that takes place on both..

Click inside both Spreadsheet and VBE - Back and forth
 

Thanks Gord -- It was the "Main" part that I was missing.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
:

Resize both windows to fit side by each.

That is......the VBE main window and the Excel main window.


Gord Dibben MS Excel MVP

On Sun, 4 Mar 2007 18:15:56 +0000, "JMay" wrote:

Can you set things up so that both
the Spreadsheet and the related VBE
can share the screen *PLUS* allow you
to (with one click) jump from one -to
the other; I'm tired on when I click
on my Spreadsheet to enter something
the VBE minimizes and I have to go back
and bring it back up in order to see any action
that takes place on both..