How to close all opened modules in Personal.xlsb excep 1st?

[Chirag R Raval]

Dear Sir,

There are about 150 above code modules in Personal.xlsb, If open personal.xlsb, it opens all modules window in VBA, requirement is only open 1st , if require another, only should be open on double click on module it self or call that module's sub.....

is there any help available to closed all modules except first of personal.xlsb?
or any setting available in VBA for tick mark option that can configure open all or 1st?

Regards,

Chirag Raval

 

[Hui]

When Personal.xlsb is opened it doesn't open any modules except the Workbook_open module. So depending on what is in the Workbook_Open module nothing normally happens.

The rest of the modules and functions are simply available to other workbooks to use if required.

 

[Chirag R Raval]

Dear Sir @Hui,

Thanks for note..& sorry for can't understand..

As we can make changes in default for excel, when open excel how many sheet there will in new excel file..
just same it , if open Personal.xlsb, how many modules windows in it should be open in VBA.

if , it default, when open personal.xlsb, its open all modules windows in it..then how to close all modules windows in it except 1st in VBA?

is there are code available to close all modules windows except 1st in personal.xlsb?

Regards,

Chirag Raval

 

[Hui]

You can't close Modules, but you should be able to view a select module if that is what you mean

I would simply close all modules except the one you want to view

Save the file and close Excel
Reopen Excel and the File
It should show you the last view

 

[Chirag R Raval]

Dear Sir,

Thanks for your valuable reply..i know that before close VBA , close all modules except 1, so we can face 1 modules when re-open excel vba...
when I 32 bit OS (win7) one Addin in VBA ghelp to close module window..

but in case, open many open modules windows..
there are any code available to close all opened modules & save Personal.xlsb?

Thanks

Regards,
Chirag Raval

 

[Hui]

Have a read of the post at:
https://www.mrexcel.com/forum/excel...-editor-solved-but-i-still-have-question.html