Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 7th 05, 03:39 PM
Chuck
 
Posts: n/a
Default Why is the menu item "Insert - Name" greyed out?

When I go to the Insert menu item and try to select Name, it is grey and I
can't select it. Why?

  #2   Report Post  
Old March 7th 05, 03:53 PM
Peo Sjoblom
 
Posts: n/a
Default

If the sheet is not protected try to reset the menu

ToolsCustomize
select insert
right click on name
select reset

if that does not work and you don't have a macro you might want to do a
search for *.xlb and rename it and restart excel


--

Regards,

Peo Sjoblom


"Chuck" wrote in message
...
When I go to the Insert menu item and try to select Name, it is grey and I
can't select it. Why?



  #3   Report Post  
Old March 7th 05, 05:25 PM
CyberTaz
 
Posts: n/a
Default

Another consideration is to make sure you are not in Edit mode. That is one
of the things you cannot do if you have a flashing insertion point in a cell.
(Just in case you were trying to insert a range name into a formula.)

HTH |:)

"Peo Sjoblom" wrote:

If the sheet is not protected try to reset the menu

ToolsCustomize
select insert
right click on name
select reset

if that does not work and you don't have a macro you might want to do a
search for *.xlb and rename it and restart excel


--

Regards,

Peo Sjoblom


"Chuck" wrote in message
...
When I go to the Insert menu item and try to select Name, it is grey and I
can't select it. Why?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM
XML Source Menu Item disabled?? File version?? Jay Lauffer Excel Discussion (Misc queries) 1 December 3rd 04 10:23 PM
Insert symbol menu Stan Excel Discussion (Misc queries) 4 December 2nd 04 12:03 AM
How to remove an Excel Main Menu item inserted by .xla file Dennis Excel Discussion (Misc queries) 5 November 28th 04 08:39 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017