Display Screen 1/2 Grid; 1/2 VBE (or at least Code Window)

  • Thread starter Thread starter Jim May
  • Start date Start date
J

Jim May

Is there a way (button, command, etc) to be able to view (quickly, and side
by side)
a my worksheet (only 1 workbook is open say) and my code window?
 
If you just want to look at macros do a cltr+' (key to left of 1).

John
North Yorkshire
UK
 
Jim

With Excel workbook open to the sheet of your choice and VBE open to your
module.....

Grab the edge of the VBE window and drag it over half way to reveal the sheet.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy cells from 4 w'sheets in multiple w'books to 1 w'sheet in 1 w'book 0
Print worksheet 2 on back of worksheet 1, etc.... 1
View workbooks side by side in Excel 2007 12
PC often crashes, at the beginning or after pixels appear 3
Which 2 in 1 or laptop for 6 year old ? 8
Find in a Grid 3
xls:1 but no xls:2 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top