add "Tools" back into Excel Toolbar

[hrm1220]

ok. I really screwed my Excel up. I was trying to delete a custom button I created in the "Tools" menu and accidentally delete the "Tools" menu

Sub DeleteMenuItem()
On Error Resume Next
CommandBars(1).FindControl(ID:=30007).Delete
end sub

I've tried replacing "Delete" with "Add" and that didn't seem to work.

Any help will be GREATLY appreciated.

 

[hrm1220]

ok. I've figured out how to get my "Tools" back into the toolbar

CommandBars.ActiveMenuBar.Reset

thx