Excel VBA - problem with adding item to Tools menu

[Mick Turner]

hello,

I tried to add a menu item under Tools menu item according to the Add-In
example in "Microsoft Office Excel 2003 Bible" book, chapter 40,
"Creating Custom Excel Add-Ins". And yes, I use Office 2003 Standard.

I got the Add-In working as a macro - that is, a new form appears having
various checkboxes for different settings (e.g. gridlines on/off,
row/column headers on/off etc.). And these are working, too.

However, using the following Sub does not work = the Toggle Settings...
menu item does not appear under Tools menu item.

Additionally, now my Tools menu item is totally missing from the menu
bar, and I cannot find it anywhere.

I think the Tools menu item is hidden, since it is shown in the
Customize - Commands window, but there are only those commands available
in the Commands list that are not normally shown under Tools menu. For
example, the Add-Ins Command is missing.

How can I restore the menu, without re-installing Excel?

Mike

 

[Norman Jones]

Hi Mick,

However, using the following Sub does not work = the Toggle Settings...
menu item does not appear under Tools menu item.

In the absence of your code, it is difficult to comment.

How can I restore the menu, without re-installing Excel?

Try:

'=============>>
Public Sub Tester()
CommandBars("Worksheet Menu Bar").Reset
End Sub
'<<=============

 

[Mick Turner]

hi,

oops, I forgot to insert the code. However, I found a solution, all it
took was to reset the "Worksheet Menu Bar".

Mike