Pick From Drop-Down List...

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top