Missing Define option from Insert/Name menu
 

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

Missing Define option from Insert/Name menu
 

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.

Roberts wrote:

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

Missing Define option from Insert/Name menu
 

That sorted it, thanks very much.

Gemma

"Dave Peterson" wrote:

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.

Roberts wrote:

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