One way is to lock your project from being viewed and if needed password
protect (VBEToolsproject properties)

Busy these days...will go through your other posts if time permits...

--
Jacob


"Faraz A. Qureshi" wrote:

Hi Jacob!

Nice to hear from u! Sure did miss u for couple of days!

No Doubt I have several add-ins I need, some examples a
PatternFills.xlam
PersonalTests.xlam

I want them to remain opened+used but it is only the several CODE windows of
each and every module of the same that I want to remain closed, when I start
VBE however, the projects remaining to be active.

Furthermore, no one has helped me out in my previous posts! Please let me
know that if I need to distribute an addin I can't find the "Package &
Deployment Wizard" under the add-ins manager in the VBE.

Any idea where to locate the same on net and downloaded?

Thanx again brother!
--
Thanx in advance,
Best Regards,

Faraz


"Jacob Skaria" wrote:

--How many open VBA projects do you see in Project Explorer?

--Check out whether you have any projects getting opened during startup. If
so remove them from your Book.xlt in XLSTART

XLSTART folder usually located at
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

--Also check out ToolsAddIns to see whether you have checked some working
files.

--
Jacob


"Faraz A. Qureshi" wrote:

Whenever, I open the VBE (Alt+F11) I find most of the code windows already
opened and have to close each and everyone by entering Ctrl+F4 and finally
opening a single module on which I seek to work upon.

Any guidance, help and relevant idea by u experts in this regard shall
highly be obliged.
--
Thanx in advance,
Best Regards,

Faraz