Standard Toolbar

[ksal]

On my standard toolbar the options (file, edit, insert, etc) appear several
times. Is there a way to change this.

 

[Dave Peterson]

Tools|customize|toolbars tab
Select the Work Sheet Menu bar and click reset.

Any customized changes you've made will have to be made again, well, if you
want.

ps. The standard toolbar is the New, Open, Save, Print, ... icons on it.

 

[Gord Dibben]

That is not the Standard Toolbar.

It is the Worksheet Menu Bar.

Tools>Customize>Toolbars.

Select the Worksheet Menu Bar and "Reset"

But if it continues to occur I would try to find out why you are getting
duplicates of File, Edit, Insert etc.

Add-ins?

Workbooks with event code?

Personal.xls doing the deed?


Gord Dibben MS Excel MVP

 

[ksal]

This worked...Thanks!

That is not the Standard Toolbar.

It is the Worksheet Menu Bar.

Tools>Customize>Toolbars.

Select the Worksheet Menu Bar and "Reset"

But if it continues to occur I would try to find out why you are getting
duplicates of File, Edit, Insert etc.

Add-ins?

Workbooks with event code?

Personal.xls doing the deed?


Gord Dibben MS Excel MVP



.