Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 586
Default Close Projects in Project Explorer

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Close Projects in Project Explorer

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

  #3   Report Post  
Posted to microsoft.public.excel.programming
Art Art is offline
external usenet poster
 
Posts: 587
Default Close Projects in Project Explorer

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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Close Projects in Project Explorer


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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 586
Default Close Projects in Project Explorer

In the VBE, I looked in the Add-InsAdd-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




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Close Projects in Project Explorer

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


  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Close Projects in Project Explorer

One other thing you might try. In Excel, ToolsAddIns 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-InsAdd-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


  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Close Projects in Project Explorer

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

In the VBE, I looked in the Add-InsAdd-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?

  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 586
Default Close Projects in Project Explorer

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

In the VBE, I looked in the Add-InsAdd-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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA project duplicated in Project Explorer teabag Excel Programming 11 December 27th 17 11:13 AM
Projects accumulate in Project Explorer Art Excel Programming 7 May 28th 07 03:32 PM
Duplicate Projects in VBE project Window... Very annoying. MikeZz Excel Programming 5 February 9th 07 08:21 PM
Old Projects in Project Window kwiklearner[_14_] Excel Programming 1 April 10th 06 06:33 PM
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. Tony Excel Programming 1 October 18th 05 03:53 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"