VBA "sheet" NOT to minimize while working on worksheet
 

Greetings all:
Am fortunate enough to have 2 monitors. In order to take most advantage of
this, I like to have both my worksheet and my VBA sheet open at the same
time. Makes it much easier to make adjustments/corrections to the code.
However, whenever I move my cursor from the code sheet to the worksheet, the
code sheet minimizes.
Is there a way to stop this "auto" minimizing of the code sheet?
If so, how?
Thanks

VBA "sheet" NOT to minimize while working on worksheet
 

I have noticed that something similar to this happens even on a single
monitor, if you switch workbooks while in Excel, if the "Collapse Project
Hides Windows" option is checked on the General tab of the Tools|Options
dialog box in the VBA editor. Projects automatically collapse (hide) when
you switch workbooks in Excel.

Try turning the "Collapse Project Hides Windows" option off (uncheck it) on
the General tab of the Tools|Options dialog box in the VBA editor.
--
Regards,
Bill Renaud

VBA "sheet" NOT to minimize while working on worksheet
 

Bill:
Thank-you. Works as expected.
It never ceases to amaze me how one little check/uncheck can cause such
frustration. I'll have to study the "tools", etc. much more carefully. I
might find some (more) hidden treasures in there.

"Bill Renaud" wrote:

I have noticed that something similar to this happens even on a single
monitor, if you switch workbooks while in Excel, if the "Collapse Project
Hides Windows" option is checked on the General tab of the Tools|Options
dialog box in the VBA editor. Projects automatically collapse (hide) when
you switch workbooks in Excel.

Try turning the "Collapse Project Hides Windows" option off (uncheck it) on
the General tab of the Tools|Options dialog box in the VBA editor.
--
Regards,
Bill Renaud