CODEWITHSUNDEEP
excelvba
DJS
DJS

Reputation: 1

When two Excel workbooks are open, each with VBA code, how do I switch the code view between workbooks?

I have two Excel workbooks, each with VBA code. However, the code window (in response to Alt-F11) only displays the VBA code associated with one workbook. I tried entering Alt-F11 again but, while the label at the top of the code window toggles between my two different spreadsheets file, only one spreadsheet's code is ever displayed.

I tried clicking all of the items in the Project window on the left side (those items related to the non-appearing code), but that didn't help.

Short of closing down one of the spreadsheets, is there any way to toggle between looking at the VBA code for two different, active spreadsheets?

Thanks!

Upvotes: 0

Views: 226

Answers (1)

Daniel Fittipaldi
Daniel Fittipaldi

Reputation: 55

You can either double click on the project explorer, or click in an element with the right button and choose "Display code". It should work.

Upvotes: 0

Related Questions