Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA project duplicated in Project Explorer | Excel Programming | |||
Projects accumulate in Project Explorer | Excel Programming | |||
Duplicate Projects in VBE project Window... Very annoying. | Excel Programming | |||
Old Projects in Project Window | Excel Programming | |||
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. | Excel Programming |