Created Dashboard that's UserForm based per mgmt request, need to know how/if having all the Forms and Module windows open (while in the *Development mode state) has any impact upon when the .xlsm kicks into it's *RUN state?

*I currently use "Unload me" with every button click (to unload the form they were just viewing before loading the new form they want to see) to TRY to prevent memory bloat or other undesirable performance issues. Not an expert, so not sure if that's 'enough'?

I was under the impression the "Unload me" would close out that UserForm or Module window on the back-end completely but that's obviously not the case when I exit RUN mode and see everything open and layered!

SCENARIO:
.xlsm file gets opened (script opens it full screen to give the look/feel of a website xlMaxmized)
There's 9 UserForms and about 20 Modules that perform different things at diff times.
Left side narrow pane holds Navigational buttons down the side, Right side large pane hold the charts, tables, metric verbiage, etc.
Forms help break out by High-Level Roll-up down to Site Level Activity/Issues (e.g., NYC, CALF, TOKYO, Top-10 Focus Areas w/ Issues, etc.)

CONCERN:
If while in their mgmt mtg, they begin to jump around, back and forth to re-look at Userforms, does the fact that the *Development area shows all the UserForms and Modules opened and layered upon each other all at once (behind the scenes) affect performance to the point of crashing?

Is the live "RUN" state totally a separate environment from the *Developer pane area in the sense, it has no bearing on when RUN kicks into place (doesn't matter if all is open on backend)?

Performance in testing seems fine so far, but haven't had it in RUN mode for 30+ minutes meeting with lots of jumping around happening to know if it's going to fail or not -- and if my UNLOAD ME is sufficient?

I looked at implementing this script to try to close all those windows in the Development backside, but it doesn't seem to work?
The Immediate window shows "Closing Module: xxxname" (with a long list as if it closed them) but when I exit RUN mode, they'll all still open.

Hopefully, you can advise the difference in the 2 states, if it matters, if Unload me is good enough, if there's a way to close all those windows OR whether or not it's ok that they're open in it's Development state.

TIA!

Please Login or Register  to view this content.