I'n my experience all you can do is protect the project, which is great for
completes add-ins you don't need to mess with, but that hides the whole thing
until you unprotect it.

HTH,

Smitty

"Gregg" wrote:

Why is that the sheet modules or "microsoft excel objects" expands
when I switch from the VBE to Excel?

In one project, I have 50+ sheet modules, which I keep collapsed while
working in my normal modules. This way I'm not distracted by all the
sheet modules when scrolling to other modules. I then switch over to
the Excel workbook to work in the cells. When I switch back to the
VBE, all the sheet modules are no longer collapsed. I have to keep
collapsing them when returning to the VBE, they won't remain
collapsed.

Is there any way to prevent this?

Thanks.