Missing Define option from Insert/Name menu

[Guest]

The Define option isn't in the Insert/Name menu and I need it to check the
named ranges already present in an Excel exporter template. I'm using Excel
2002 on XP. Does anyone know how to locate this option please?

Thanks very much,
Gemma

 

[Dave Peterson]

Maybe you could reset that toolbar to bring it back (and lose any customized
changes you've made????).

If you want to try:
Tools|customize|toolbars tab
select the worksheet menu bar
click the reset button

And see if it's back.

 

[Guest]

That sorted it, thanks very much.

Gemma

Maybe you could reset that toolbar to bring it back (and lose any customized
changes you've made????).

If you want to try:
Tools|customize|toolbars tab
select the worksheet menu bar
click the reset button

And see if it's back.