| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't get a drop down list when a do a right click on a cell
When I am in Excel and do a right mouse click I do not see the drop down list
that shows the available commands (i.e. cut, copy, etc.). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't get a drop down list when a do a right click on a cell
Perhaps your right-click has been altered by a macro you ran.
Hit ALT + F11 to go to the VBEditor. Then ViewImmediate Window. Copy/paste this line into the window and hit <enter Application.CommandBars("Cell").Enabled = True OR copy/paste this sub to a module and run it. Sub reset() Application.CommandBars("Cell").Enabled = True End Sub Do you now have a right-click menu? If so, I would start looking for what disabled it in the first place. Gord Dibben MS Excel MVP On Thu, 9 Mar 2006 08:39:08 -0800, csanchez wrote: When I am in Excel and do a right mouse click I do not see the drop down list that shows the available commands (i.e. cut, copy, etc.). Gord Dibben MS Excel MVP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't get a drop down list when a do a right click on a cell
That fixed the problem. It must have been altered by a macro because it
started happening after running a macro. Thanks! "Gord Dibben" wrote: Perhaps your right-click has been altered by a macro you ran. Hit ALT + F11 to go to the VBEditor. Then ViewImmediate Window. Copy/paste this line into the window and hit <enter Application.CommandBars("Cell").Enabled = True OR copy/paste this sub to a module and run it. Sub reset() Application.CommandBars("Cell").Enabled = True End Sub Do you now have a right-click menu? If so, I would start looking for what disabled it in the first place. Gord Dibben MS Excel MVP On Thu, 9 Mar 2006 08:39:08 -0800, csanchez wrote: When I am in Excel and do a right mouse click I do not see the drop down list that shows the available commands (i.e. cut, copy, etc.). Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a conditional cell from a drop down list in Excel | Excel Worksheet Functions | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
| Creating drop down list for multiple cell ranges | Excel Discussion (Misc queries) | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
Linear Mode
