Close Projects in Project Explorer

[RyanH]

I have 5 projects that are in my Project Explorer everytime I open Excel at
my work computer. I have no idea what these projects do. Is there a way to
remove them? My home computer does not have them and I am able to run all my
macros that I developed just fine.

 

[JLGWhiz]

Don't try to remove FunCres whatever you do. What you should do is have your
IT look at it to see if it is something required by local authority. I would
not delete anything from a company workstation without checking with the
technical folks first, unless it was something that I personally installed.
I also would not delete it based on advice from anyone outside the company.

 

[RyanH]

In the VBE, I looked in the Add-Ins>Add-In Manager and saw nothing. Our IT
guys dosn't have a clue. One of the projects is a PDF maker that I never
use, plus another is an Add-in from Crystal Reports but I see no way to
remove it. Any ideas on how?

 

[JLGWhiz]

I suspect that what you have are .xla add-ins that perform special functions
like making .pdf files, etc. They are probably password protected to prevent
removal or tampering. They might not show in the regular add in listing
because they are part of that particular workbook. An alternative would be
to move your project to a new workbook and rename the old one. If it was
important to someone, you will find out shortly.

 

[JLGWhiz]

One other thing you might try. In Excel, Tools>AddIns and if they are listed
there, try deselecting to see if that makes them go away.

 

[Chip Pearson]

They might be workbooks that are referenced by your "normal"
workbook(s). If a workbook has a reference (in the VBA/VBE meaning of
"reference", not a cell/formula "reference"), Excel will open the
referenced workbook when the workbook referencing that workbook is
opened. The referenced workbook may be configured so as not to be
visible in the Excel UI.

Also, you might want to examine your Registry settings. (Be VERY
CAREFUL, though, when working with the Registry. All updates and
changes are done "live" and there is no "undo" or "close without save"
option.) From the Windows Start menu, choose Run, then enter RegEdit.
There, navigate to the HKEY_CURRENT_USER region and find the key

Software\Microsoft\Office\11.0\Excel\Add-in Manager

Change the 11.0 to your version (10.0 = 2002, 11.0 = 2003, 12.0 =
2007). See what add-ins are listed there and if you don't want or need
them, delete their values. Also, go to the key

Software\Microsoft\Office\11.0\Excel\Options

Look for values whose name begins with "OPEN". If you don't want/need
the files in those values, delete the values.

Also, examine the key

Software\Microsoft\Office\Excel\AddIns

If there are add-ins there that you don't want/need, delete the
values.

Nagivate to the HKEY_LOCAL_MACHINE region and examine the values in
the key and subkeys:

SOFTWARE\Microsoft\Office\11.0

Again, if you find references to add-ins or files you don't want/need,
delete their values.

As noted before, be VERY CAREFUL when working with the Registry and
RegEdit. If you delete the wrong key or value, applications may
misbehave or fail to start. In the worst case, Windows itself may not
be able to start. Be VERY CAREFUL.

If you do find that you are not happy with the Registry changes you
made, you can restore Excel's Registry items to "factory defaults".
With Excel closed, go to the Windows Start menu, choose Run, and enter


Excel.exe /regserver

You may have to include the entire path to Excel. E.g.,

"C:\Program Files\Microsoft Office\Office11\Excel.exe" /regserver



Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[RyanH]

Thanks again Chip!
--
Cheers,
Ryan

They might be workbooks that are referenced by your "normal"
workbook(s). If a workbook has a reference (in the VBA/VBE meaning of
"reference", not a cell/formula "reference"), Excel will open the
referenced workbook when the workbook referencing that workbook is
opened. The referenced workbook may be configured so as not to be
visible in the Excel UI.

Also, you might want to examine your Registry settings. (Be VERY
CAREFUL, though, when working with the Registry. All updates and
changes are done "live" and there is no "undo" or "close without save"
option.) From the Windows Start menu, choose Run, then enter RegEdit.
There, navigate to the HKEY_CURRENT_USER region and find the key

Software\Microsoft\Office\11.0\Excel\Add-in Manager

Change the 11.0 to your version (10.0 = 2002, 11.0 = 2003, 12.0 =
2007). See what add-ins are listed there and if you don't want or need
them, delete their values. Also, go to the key

Software\Microsoft\Office\11.0\Excel\Options

Look for values whose name begins with "OPEN". If you don't want/need
the files in those values, delete the values.

Also, examine the key

Software\Microsoft\Office\Excel\AddIns

If there are add-ins there that you don't want/need, delete the
values.

Nagivate to the HKEY_LOCAL_MACHINE region and examine the values in
the key and subkeys:

SOFTWARE\Microsoft\Office\11.0

Again, if you find references to add-ins or files you don't want/need,
delete their values.

As noted before, be VERY CAREFUL when working with the Registry and
RegEdit. If you delete the wrong key or value, applications may
misbehave or fail to start. In the worst case, Windows itself may not
be able to start. Be VERY CAREFUL.

If you do find that you are not happy with the Registry changes you
made, you can restore Excel's Registry items to "factory defaults".
With Excel closed, go to the Windows Start menu, choose Run, and enter


Excel.exe /regserver

You may have to include the entire path to Excel. E.g.,

"C:\Program Files\Microsoft Office\Office11\Excel.exe" /regserver



Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[art]

I have the FUncres.xlam when I open up excel. What is it for? Why is it
there? Isn't all built-in add-ins hidden?