Hi

I'm trying to define a named range, but the option InsertNameDefine
is not listed.
It's been there before, but now it's not!
Any suggestions on how to get it back?
I'm using Excel 2000

Thanks

If the name is not in the list, it was deleted or had its Visible
property set to False. To restore a hidden name, run the
following code:

Sub AAA()
ThisWorkbook.Names("TheName").Visible = True
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Brip" wrote in message
oups.com...
Hi

I'm trying to define a named range, but the option
InsertNameDefine
is not listed.
It's been there before, but now it's not!
Any suggestions on how to get it back?
I'm using Excel 2000

Thanks

Thanks for the reply, but it's not that a specific name is missing,
rather the option to Define names in the first place is not there.
So previously when I've created a new name, I've gone to
InsertNameDefine, which brings up the Define names dialogue box.
However now the Define option is not there I can't see how to create a
name range or manage them (which I've always done through this Define
dialogue).

Any advice gratefully received...

This will happen if the worksheet is protected. Go to the Tools
menu, choose Protection, then Unprotect Sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Brip" wrote in message
ups.com...
Thanks for the reply, but it's not that a specific name is
missing,
rather the option to Define names in the first place is not
there.
So previously when I've created a new name, I've gone to
InsertNameDefine, which brings up the Define names dialogue
box.
However now the Define option is not there I can't see how to
create a
name range or manage them (which I've always done through this
Define
dialogue).

Any advice gratefully received...

Thanks again, I appreciate your help.

However the sheet or workbook is not protected.
I've just tried a colleagues machine and it works fine (the Define
option there, happy as Larry), so I've been able to solve my immediate
problem on his machine.
But my Excel still has Define missing!

Is it going to be a case reinstall Excel or is there some obvious
option to turn the Define 'on/off'?

You might try resetting your toolbars. Under View, Toolbars, Customize, on
the Toolbars tab select Worksheet Menu Bar (near the end) and click Reset.

Also, an easy way to open the Define Name dialog directly is via Ctrl-F3.

--
Jim
"Brip" wrote in message
ups.com...
| Thanks again, I appreciate your help.
|
| However the sheet or workbook is not protected.
| I've just tried a colleagues machine and it works fine (the Define
| option there, happy as Larry), so I've been able to solve my immediate
| problem on his machine.
| But my Excel still has Define missing!
|
| Is it going to be a case reinstall Excel or is there some obvious
| option to turn the Define 'on/off'?
|

You can add the menu item back onto the menu by going into Tools\Customize
then the commands tab. Choose Built-in menus from the left side and the Name
Item on the right side. Pull down the Insert menu, (customize is still open)
and put the Name item back onto the Insert Menu. Not sure how it disappeared
but you can put any menu item back on this way.

"Brip" wrote:

Hi

I'm trying to define a named range, but the option InsertNameDefine
is not listed.
It's been there before, but now it's not!
Any suggestions on how to get it back?
I'm using Excel 2000

Thanks

Thanks all.

The ctrl+F3 option works. However, I have reset the toolbars, and tried
the the built-in menu option. All to no avail.
It STILL does not show up in the Built-in Name menu.
I'll just go on using the keyboard shortcut option.

You can reset all the toolbars by this:

Close excel
windows start button|search
look for *.xlb
look in for hidden files and through hidden folders, too.
Delete them.

This will get rid of any customized change to any toolbar.

Brip wrote:

Thanks all.

The ctrl+F3 option works. However, I have reset the toolbars, and tried
the the built-in menu option. All to no avail.
It STILL does not show up in the Built-in Name menu.
I'll just go on using the keyboard shortcut option.

--

Dave Peterson