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.
--
Cheers,
Ryan

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" wrote:

> 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.
> --
> Cheers,
> Ryan

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?
--
Cheers,
Ryan


"shg" wrote:

>
> Add-ins, most likely. What are their names?
>
>
> --
> shg
> ------------------------------------------------------------------------
> shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
> View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30678
>
>

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.

"RyanH" wrote:

> 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?
> --
> Cheers,
> Ryan
>
>
> "shg" wrote:
>
> >
> > Add-ins, most likely. What are their names?
> >
> >
> > --
> > shg
> > ------------------------------------------------------------------------
> > shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
> > View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30678
> >
> >

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.

"RyanH" wrote:

> 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?
> --
> Cheers,
> Ryan
>
>
> "shg" wrote:
>
> >
> > Add-ins, most likely. What are their names?
> >
> >
> > --
> > shg
> > ------------------------------------------------------------------------
> > shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
> > View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30678
> >
> >

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)




On Mon, 17 Nov 2008 15:05:02 -0800, RyanH
<(E-Mail Removed)> wrote:

>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?

Thanks again Chip!
--
Cheers,
Ryan


"Chip Pearson" wrote:

> 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)
>
>
>
>
> On Mon, 17 Nov 2008 15:05:02 -0800, RyanH
> <(E-Mail Removed)> wrote:
>
> >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?
>

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?

"JLGWhiz" wrote:

> 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" wrote:
>
> > 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.
> > --
> > Cheers,
> > Ryan