Open multiple VBE while using multiple monitors

[Beatrix]

Hi All,

I am using multiple monitors and working on separate spreadsheets. I have a spreadsheet open in each monitor. Even I open them in separate Excel application when I open the VBE it lists all VBA projects on the same platform. Is there a way to open a separate VBE for each spreadsheet?

Cheers
B.

[Aflatoon]

If you open them in separate instances you will get a separate VBE for each.

[Beatrix]

If you open them in separate instances you will get a separate VBE for each.

When you say separate instances you mean separate excel applications? Even I open then in separate excel apps. All VBA projects pop up to the same screen. It lists all vba projects under the same tree. I want to extend each VBA project to different monitors. Is it possible?

[Aflatoon]

Each VBE will show each workbook that is open in that application instance. It will not show workbooks open in another application instance. Within an application instance you can only have one VBE though.

[Beatrix]

Sorry it is my my mistake. It comes up with separate VBE.