Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there
My accounting program have introduced a so-called Business Intelligence module and have taken the liberty of adding an additional Worksheet Menu Bar item named "Report Tools" with some additional sub-menus. I have tried deleting the menu item as well as reset the Worksheet Menu Bar which removes the additional item for the current Excel session. I have also tried deleting the Excel.xlb file. As soon as I restart Excel, the additional item is added. There are no add-ins installed. There are no files in the Xlstart folders (Office or User). Much as I want to permanently remove the additional menu item, I am intrigued to know how it is added. Can anybody help? Thanks Michael |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Most likely is will be added via a com addin...but there would be other means.. either customize your toolbar so you can get to the ComAddins dialog, or simply check the registry: look at HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Add-in Manager and the OPEN lines in HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Michael Rekas wrote : Hi there My accounting program have introduced a so-called Business Intelligence module and have taken the liberty of adding an additional Worksheet Menu Bar item named "Report Tools" with some additional sub-menus. I have tried deleting the menu item as well as reset the Worksheet Menu Bar which removes the additional item for the current Excel session. I have also tried deleting the Excel.xlb file. As soon as I restart Excel, the additional item is added. There are no add-ins installed. There are no files in the Xlstart folders (Office or User). Much as I want to permanently remove the additional menu item, I am intrigued to know how it is added. Can anybody help? Thanks Michael |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there keepITcool
Looked in the registry - Nothing but (Default) Type - REG_SZ with (value not set.) in Add-in Manager In Options - No Open key. Please could you explain further what you mean by customize the toolbar to get to the ComAddins dialog. Could not work out how to do this. Thanks Michael P.S. Whoops! Sorry for the mispelling of Worksheet in the Subject line!! On Sat, 02 Jul 2005 07:06:55 -0700, "keepITcool" wrote: Most likely is will be added via a com addin...but there would be other means.. either customize your toolbar so you can get to the ComAddins dialog, or simply check the registry: look at HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Add-in Manager and the OPEN lines in HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Options |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there
Looked again in the registry and located the add-in in the HKEY_LOCAL_MACHINE section. Deleted the key and it sorted out the problem. I would appreciate it if you could point me in a direction to find out more about com add-ins. Thanks for the help. Regards Michael On Sat, 02 Jul 2005 07:06:55 -0700, "keepITcool" wrote: Most likely is will be added via a com addin...but there would be other means.. either customize your toolbar so you can get to the ComAddins dialog, or simply check the registry: look at HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Add-in Manager and the OPEN lines in HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Options |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Michael,
I would appreciate it if you could point me in a direction to find out more about com add-ins. As a starting point, see the following MSDN articles: http://tinyurl.com/5vsx --- Regards, Norman "Michael Rekas" wrote in message ... Hi there Looked again in the registry and located the add-in in the HKEY_LOCAL_MACHINE section. Deleted the key and it sorted out the problem. I would appreciate it if you could point me in a direction to find out more about com add-ins. Thanks for the help. Regards Michael |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Norman
Very helpful. Rgds Michael On Sat, 2 Jul 2005 18:50:01 +0100, "Norman Jones" wrote: Hi Michael, I would appreciate it if you could point me in a direction to find out more about com add-ins. As a starting point, see the following MSDN articles: http://tinyurl.com/5vsx --- Regards, Norman "Michael Rekas" wrote in message .. . Hi there Looked again in the registry and located the add-in in the HKEY_LOCAL_MACHINE section. Deleted the key and it sorted out the problem. I would appreciate it if you could point me in a direction to find out more about com add-ins. Thanks for the help. Regards Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming |