Define Name option missing??

B

Brip

Hi

I'm trying to define a named range, but the option Insert>>Name>>Define
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
 
C

Chip Pearson

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
 
B

Brip

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
Insert>>Name>>Define, 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...
 
C

Chip Pearson

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
 
B

Brip

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'?
 
J

Jim Rech

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
| 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'?
|
 
D

donna

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.
 
B

Brip

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.
 
D

Dave Peterson

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.
 
Top