Pick From Drop-Down List...

G

Guest

I have created a list in cells A2 thru A13. A1 has text 'Month & Yr'
entered. When I right-click in A14, I do not have the option of Pick From
Drop-Down List... appear. I have this in another file that was converted
over from Excel 2000 & it works fine. What am I missing in Excel 2003?

Thanx! Mary
 
G

Gord Dibben

No "pick from list" selection appearing at all?

How about you reset the right-click menu.

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using drop-down lists 4
Excel 2007 / right-click / pick from drop down list 1
can I create a drop down list to pick a date ? 3
Vlookups not working 2
How do I create a drop down box within a drop down box? 1
Pick from drop-down list gives empty or erroneous result 6
Formatted cell column in drop down list 1
Sum from a Drop down menu using value in the cell below 11

Top