lost sub menu

[Dean]

I was going in to change my security level i went to
tools /macro and security is gone all's that is there is
macros, record new macros, visual basic editor,......it
used to be there. how can i get it back?

thanks
Dean

 

[Ron de Bruin]

Hi Dean

You can reset your menubar to default
Right click on the menubar and choose customize

Under Toolbars select the worksheet menu bar
and click on reset

You lost all the things you changed to the menubar

 

[Gord Dibben]

Dean

An alternative to Ron's suggestion.

Go to Tools>Customize>Commands.

Scroll down to Tools category and find "Security".

Drag it up to your Tools>Macro Submenu.

No re-setting involved.

Gord Dibben Excel MVP