I accidently deleted Tools Menu Bar in VBE, any ideas to get it back 1

[WantsToLearn]

That's what I get for working in the middle of the night. I added a new control on the tools menu using with VBE, etc and copied the same with / end with pair down to where I was deleting the new control and neglected to extend the with / end with pair to .Controls, ect.

Any ideas out there about how to get it back? I bought the computer used so have no idea where the install disks are to run a fix. I did this in Excel2000, if that makes a difference to anyone.

I asked for it, so feel free to make the obligatory "You should have backed up first", "You should have copied the menu to a workmenu", etc. All at once, I'm a lot more tired than I should be.

Hope your day goes better than mine started out as...

 

[TonyJollans]

Hi WantsToLearn,

The Tools menu Bar is built in - you shouldn't be able to 'delete' it. What I presume you have done is removed it from the main Menu Bar.

Right Click on the Menu Bar and select Customize
Select the Commands tab
Under Categories, scroll down and Select Built-in Menus
Under Commands, scroll down and click and drag Tools back to where you want it.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[WantsToLearn]

Thanks Tony! I hadn't paniced yet, but I wasn't looking forward to the process. You saved me a lot of time and grief. Have a good day!