Remove item from Tools menu
 

Hi everyone Happy New Year
At some point in the distant past I put in place a Worksheet macro to run a
Drop Down list. Some where along the line I also added a command button to
the Tools menu, the purpose of which is now unclear as the Drop Down List Box
is permanently displayed. Macro places my selection in the active cell and
resets the Drop Down window to blank.
My problem is that what ever I do I can not permanently delete/remove this
button from the Tools menu. It is removed from the menu when I go
ToolsCustomizeToolsRight Click on buttonDelete but when ever I open the
Workbook again it has returned. Not sure if relevant but if I create a new
Workbook while in the one with the 'rouge' button the problem is recreated.
Interestingly if I copy even a single cell from 'faulty' Workbook to a
'clean' one the 'rouge' button is inserted on the Tools menu of the new
'clean' Wrkbook. Again unsure if relevant but this particular Workbook was
originally created in Excel 95 where as I am now using 2003.
Only place I can find/see any reference to the 'Button' is when I open the
Workbook with Notepad.
Does any one have any suggestions?

Regards
Arran

Remove item from Tools menu
 

Arran,

Have you looked through the code to see if this button is being created
programatically?
--
http://HelpExcel.com




"Arran" wrote:

Hi everyone Happy New Year
At some point in the distant past I put in place a Worksheet macro to run a
Drop Down list. Some where along the line I also added a command button to
the Tools menu, the purpose of which is now unclear as the Drop Down List Box
is permanently displayed. Macro places my selection in the active cell and
resets the Drop Down window to blank.
My problem is that what ever I do I can not permanently delete/remove this
button from the Tools menu. It is removed from the menu when I go
ToolsCustomizeToolsRight Click on buttonDelete but when ever I open the
Workbook again it has returned. Not sure if relevant but if I create a new
Workbook while in the one with the 'rouge' button the problem is recreated.
Interestingly if I copy even a single cell from 'faulty' Workbook to a
'clean' one the 'rouge' button is inserted on the Tools menu of the new
'clean' Wrkbook. Again unsure if relevant but this particular Workbook was
originally created in Excel 95 where as I am now using 2003.
Only place I can find/see any reference to the 'Button' is when I open the
Workbook with Notepad.
Does any one have any suggestions?

Regards
Arran

Remove item from Tools menu
 

Thank you both for your suggestions.

Tom, will try out your suggestion as problem is only with this Book that was
created with Excel 95 and not any created with 2003

galimi, below is the code for the Drop down list. The Macro that is being
called when the 'rouge' button is clicked on has been deleted from the
Workbook.

Sub control_on_worksheet()
Dim mypick As Variant
With Worksheets("April 04 - April 05").DropDowns("Details")
' set the value of mypick to the index number
' of the item chosen in the drop-down.
mypick = .ListIndex
'extract the actual item and put it into
'the active cell on the worksheet.
ActiveCell.Value = .List(mypick)
'empty out the drop-down.
.Value = 0
End With
End Sub

Many thanks to you both

Arran



"Tom Ogilvy" wrote:

Menu customizations in Excel 95 were done with the Menu Editor. They are
attached to the workbook. Jim Rech has written a utility to remove them.
You can get a copy at Stephen Bullen's site on the MVP page

http://www.oaltd.co.uk/MVP/Default.htm


or directly:
http://www.oaltd.co.uk/DLCount/DLCou...emoveMenus.zip
RemoveMenus.zip (12 April 2000, 10k, 10797 downloads)
RemoveMenus is a utility for removing custom menus created by the Excel 5/95
menu editor from workbooks. When a workbook is converted to Excel 97/2000
format without first removing these menus there is no way to do so in Excel
97/2000. Converting back to Excel 5/95 format may not be a good option as
Excel 97/2000 specific enhancements will be lost. Use File, Open to load the
add-in. "Remove Menu Editor Edits" on the Tools menu will start it. The
utility will work on closed workbooks only.

--
Regards,
Tom Ogilvy


"Arran" wrote in message
...
Hi everyone Happy New Year
At some point in the distant past I put in place a Worksheet macro to run
a
Drop Down list. Some where along the line I also added a command button to
the Tools menu, the purpose of which is now unclear as the Drop Down List
Box
is permanently displayed. Macro places my selection in the active cell and
resets the Drop Down window to blank.
My problem is that what ever I do I can not permanently delete/remove this
button from the Tools menu. It is removed from the menu when I go
ToolsCustomizeToolsRight Click on buttonDelete but when ever I open
the
Workbook again it has returned. Not sure if relevant but if I create a new
Workbook while in the one with the 'rouge' button the problem is
recreated.
Interestingly if I copy even a single cell from 'faulty' Workbook to a
'clean' one the 'rouge' button is inserted on the Tools menu of the new
'clean' Wrkbook. Again unsure if relevant but this particular Workbook was
originally created in Excel 95 where as I am now using 2003.
Only place I can find/see any reference to the 'Button' is when I open the
Workbook with Notepad.
Does any one have any suggestions?

Regards
Arran

Remove item from Tools menu
 

Hi Tom

Brilliant! Used the direct approach, no more 'rouge' button.

Many thanks

Arran

"Tom Ogilvy" wrote:

Menu customizations in Excel 95 were done with the Menu Editor. They are
attached to the workbook. Jim Rech has written a utility to remove them.
You can get a copy at Stephen Bullen's site on the MVP page

http://www.oaltd.co.uk/MVP/Default.htm


or directly:
http://www.oaltd.co.uk/DLCount/DLCou...emoveMenus.zip
RemoveMenus.zip (12 April 2000, 10k, 10797 downloads)
RemoveMenus is a utility for removing custom menus created by the Excel 5/95
menu editor from workbooks. When a workbook is converted to Excel 97/2000
format without first removing these menus there is no way to do so in Excel
97/2000. Converting back to Excel 5/95 format may not be a good option as
Excel 97/2000 specific enhancements will be lost. Use File, Open to load the
add-in. "Remove Menu Editor Edits" on the Tools menu will start it. The
utility will work on closed workbooks only.

--
Regards,
Tom Ogilvy


"Arran" wrote in message
...
Hi everyone Happy New Year
At some point in the distant past I put in place a Worksheet macro to run
a
Drop Down list. Some where along the line I also added a command button to
the Tools menu, the purpose of which is now unclear as the Drop Down List
Box
is permanently displayed. Macro places my selection in the active cell and
resets the Drop Down window to blank.
My problem is that what ever I do I can not permanently delete/remove this
button from the Tools menu. It is removed from the menu when I go
ToolsCustomizeToolsRight Click on buttonDelete but when ever I open
the
Workbook again it has returned. Not sure if relevant but if I create a new
Workbook while in the one with the 'rouge' button the problem is
recreated.
Interestingly if I copy even a single cell from 'faulty' Workbook to a
'clean' one the 'rouge' button is inserted on the Tools menu of the new
'clean' Wrkbook. Again unsure if relevant but this particular Workbook was
originally created in Excel 95 where as I am now using 2003.
Only place I can find/see any reference to the 'Button' is when I open the
Workbook with Notepad.
Does any one have any suggestions?

Regards
Arran