Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good afternoon, all,
Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Version?
Have you tried using the f2 key -- Don Guillett Microsoft MVP Excel SalesAid Software "Pete Rooney" wrote in message ... Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Don,
Excel 2003 SP3 Sorry, why would I use F2? - I did Alt-E then F2, just in case, but it didn't work! :-) Just puzzled Alt-E worked yesterday, but it doesn't today... Cheers Pete "Don Guillett" wrote: Version? Have you tried using the f2 key -- Don Guillett Microsoft MVP Excel SalesAid Software "Pete Rooney" wrote in message ... Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Expanding on Jim's comment - I you or someone has added a new menu item to
the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Shane, Jim,
No new menu items were added onto the menu bar. When I do Alt-E, it just highlights the "Edit" command and i have to press [Enter] to see the "Edit" sub commands. Doesn't sound like much of a problem, but when you're keyboard bound like me for adding & deleting rows, columns and cell, having to add an extra [Enter] in the mioddle is a real bind! The only other thing that happened in our world between it working and not was a change to group policies affecting the running of macros - not sure if that rings a bell with anyone..? Oh, and by the way, it's not specific to any one worksheet - it does it as soon as Excel opens. Thanks for your help Pete "ShaneDevenshire" wrote: Expanding on Jim's comment - I you or someone has added a new menu item to the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hit alt-e to see the Edit option depressed.
Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) Pete Rooney wrote: Shane, Jim, No new menu items were added onto the menu bar. When I do Alt-E, it just highlights the "Edit" command and i have to press [Enter] to see the "Edit" sub commands. Doesn't sound like much of a problem, but when you're keyboard bound like me for adding & deleting rows, columns and cell, having to add an extra [Enter] in the mioddle is a real bind! The only other thing that happened in our world between it working and not was a change to group policies affecting the running of macros - not sure if that rings a bell with anyone..? Oh, and by the way, it's not specific to any one worksheet - it does it as soon as Excel opens. Thanks for your help Pete "ShaneDevenshire" wrote: Expanding on Jim's comment - I you or someone has added a new menu item to the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete -- Dave Peterson |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dave (and all),
Nope, I'm afraid I haven't added any additional menu commands. It's just the standard Worksheet menu. I'm stumped. Pete "Dave Peterson" wrote: Hit alt-e to see the Edit option depressed. Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) Pete Rooney wrote: Shane, Jim, No new menu items were added onto the menu bar. When I do Alt-E, it just highlights the "Edit" command and i have to press [Enter] to see the "Edit" sub commands. Doesn't sound like much of a problem, but when you're keyboard bound like me for adding & deleting rows, columns and cell, having to add an extra [Enter] in the mioddle is a real bind! The only other thing that happened in our world between it working and not was a change to group policies affecting the running of macros - not sure if that rings a bell with anyone..? Oh, and by the way, it's not specific to any one worksheet - it does it as soon as Excel opens. Thanks for your help Pete "ShaneDevenshire" wrote: Expanding on Jim's comment - I you or someone has added a new menu item to the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete -- Dave Peterson |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
So when you hit alt-e and then enter, what happened?
If you hit alt-e twice, then enter, what happened? Pete Rooney wrote: Dave (and all), Nope, I'm afraid I haven't added any additional menu commands. It's just the standard Worksheet menu. I'm stumped. Pete "Dave Peterson" wrote: Hit alt-e to see the Edit option depressed. Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) Pete Rooney wrote: Shane, Jim, No new menu items were added onto the menu bar. When I do Alt-E, it just highlights the "Edit" command and i have to press [Enter] to see the "Edit" sub commands. Doesn't sound like much of a problem, but when you're keyboard bound like me for adding & deleting rows, columns and cell, having to add an extra [Enter] in the mioddle is a real bind! The only other thing that happened in our world between it working and not was a change to group policies affecting the running of macros - not sure if that rings a bell with anyone..? Oh, and by the way, it's not specific to any one worksheet - it does it as soon as Excel opens. Thanks for your help Pete "ShaneDevenshire" wrote: Expanding on Jim's comment - I you or someone has added a new menu item to the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete -- Dave Peterson -- Dave Peterson |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The next thing I'd try is to turn off all the visible toolbars and add them back
one at a time. Tools|Customize (keep track of all the ones that are checked) Uncheck all of them except worksheet menu bar Then try the alt-e combination. If it doesn't work, look for problem on that worksheet menu bar. If it works ok, add a toolbar and try it again. Lather, rinse, repeat. Dave Peterson wrote: So when you hit alt-e and then enter, what happened? If you hit alt-e twice, then enter, what happened? Pete Rooney wrote: Dave (and all), Nope, I'm afraid I haven't added any additional menu commands. It's just the standard Worksheet menu. I'm stumped. Pete "Dave Peterson" wrote: Hit alt-e to see the Edit option depressed. Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) Pete Rooney wrote: Shane, Jim, No new menu items were added onto the menu bar. When I do Alt-E, it just highlights the "Edit" command and i have to press [Enter] to see the "Edit" sub commands. Doesn't sound like much of a problem, but when you're keyboard bound like me for adding & deleting rows, columns and cell, having to add an extra [Enter] in the mioddle is a real bind! The only other thing that happened in our world between it working and not was a change to group policies affecting the running of macros - not sure if that rings a bell with anyone..? Oh, and by the way, it's not specific to any one worksheet - it does it as soon as Excel opens. Thanks for your help Pete "ShaneDevenshire" wrote: Expanding on Jim's comment - I you or someone has added a new menu item to the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#12
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dave,
You did it! Of all the stupid things, I had a "Replace" tool on the Standard toolbar whose accelerator key was..? Thanks a million. Pete "Dave Peterson" wrote: The next thing I'd try is to turn off all the visible toolbars and add them back one at a time. Tools|Customize (keep track of all the ones that are checked) Uncheck all of them except worksheet menu bar Then try the alt-e combination. If it doesn't work, look for problem on that worksheet menu bar. If it works ok, add a toolbar and try it again. Lather, rinse, repeat. Dave Peterson wrote: So when you hit alt-e and then enter, what happened? If you hit alt-e twice, then enter, what happened? Pete Rooney wrote: Dave (and all), Nope, I'm afraid I haven't added any additional menu commands. It's just the standard Worksheet menu. I'm stumped. Pete "Dave Peterson" wrote: Hit alt-e to see the Edit option depressed. Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) Pete Rooney wrote: Shane, Jim, No new menu items were added onto the menu bar. When I do Alt-E, it just highlights the "Edit" command and i have to press [Enter] to see the "Edit" sub commands. Doesn't sound like much of a problem, but when you're keyboard bound like me for adding & deleting rows, columns and cell, having to add an extra [Enter] in the mioddle is a real bind! The only other thing that happened in our world between it working and not was a change to group policies affecting the running of macros - not sure if that rings a bell with anyone..? Oh, and by the way, it's not specific to any one worksheet - it does it as soon as Excel opens. Thanks for your help Pete "ShaneDevenshire" wrote: Expanding on Jim's comment - I you or someone has added a new menu item to the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#13
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm gonna guess it was &e!
Glad you found it. Pete Rooney wrote: Dave, You did it! Of all the stupid things, I had a "Replace" tool on the Standard toolbar whose accelerator key was..? Thanks a million. Pete "Dave Peterson" wrote: The next thing I'd try is to turn off all the visible toolbars and add them back one at a time. Tools|Customize (keep track of all the ones that are checked) Uncheck all of them except worksheet menu bar Then try the alt-e combination. If it doesn't work, look for problem on that worksheet menu bar. If it works ok, add a toolbar and try it again. Lather, rinse, repeat. Dave Peterson wrote: So when you hit alt-e and then enter, what happened? If you hit alt-e twice, then enter, what happened? Pete Rooney wrote: Dave (and all), Nope, I'm afraid I haven't added any additional menu commands. It's just the standard Worksheet menu. I'm stumped. Pete "Dave Peterson" wrote: Hit alt-e to see the Edit option depressed. Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) Pete Rooney wrote: Shane, Jim, No new menu items were added onto the menu bar. When I do Alt-E, it just highlights the "Edit" command and i have to press [Enter] to see the "Edit" sub commands. Doesn't sound like much of a problem, but when you're keyboard bound like me for adding & deleting rows, columns and cell, having to add an extra [Enter] in the mioddle is a real bind! The only other thing that happened in our world between it working and not was a change to group policies affecting the running of macros - not sure if that rings a bell with anyone..? Oh, and by the way, it's not specific to any one worksheet - it does it as soon as Excel opens. Thanks for your help Pete "ShaneDevenshire" wrote: Expanding on Jim's comment - I you or someone has added a new menu item to the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#14
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dave,
I didn't give it Alt-E - that's what it had already, but yes - you're right. Thanks for pointing me in the right direction, mate! Pete "Dave Peterson" wrote: I'm gonna guess it was &e! Glad you found it. Pete Rooney wrote: Dave, You did it! Of all the stupid things, I had a "Replace" tool on the Standard toolbar whose accelerator key was..? Thanks a million. Pete "Dave Peterson" wrote: The next thing I'd try is to turn off all the visible toolbars and add them back one at a time. Tools|Customize (keep track of all the ones that are checked) Uncheck all of them except worksheet menu bar Then try the alt-e combination. If it doesn't work, look for problem on that worksheet menu bar. If it works ok, add a toolbar and try it again. Lather, rinse, repeat. Dave Peterson wrote: So when you hit alt-e and then enter, what happened? If you hit alt-e twice, then enter, what happened? Pete Rooney wrote: Dave (and all), Nope, I'm afraid I haven't added any additional menu commands. It's just the standard Worksheet menu. I'm stumped. Pete "Dave Peterson" wrote: Hit alt-e to see the Edit option depressed. Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) Pete Rooney wrote: Shane, Jim, No new menu items were added onto the menu bar. When I do Alt-E, it just highlights the "Edit" command and i have to press [Enter] to see the "Edit" sub commands. Doesn't sound like much of a problem, but when you're keyboard bound like me for adding & deleting rows, columns and cell, having to add an extra [Enter] in the mioddle is a real bind! The only other thing that happened in our world between it working and not was a change to group policies affecting the running of macros - not sure if that rings a bell with anyone..? Oh, and by the way, it's not specific to any one worksheet - it does it as soon as Excel opens. Thanks for your help Pete "ShaneDevenshire" wrote: Expanding on Jim's comment - I you or someone has added a new menu item to the Worksheet Menu Bar and it has the shortcut key Alt+E then there is a problem. Simplest way around this is to change the shortcut for the new command - choose View, Toolbar, Customize. Then right click the menu command and in the Name property on the shortcut menu put the & sign in front of a letter other than E (in front of a letter not being used by one of the other menu items. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jim Cone" wrote: That can happen when there is more than one menu item with the same accelerator key. Have you added something to the menu bar? Repeat the Alt + E keystrokes and see what gets highlighted. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Pete Rooney" wrote in message Good afternoon, all, Until yesterday, Alt-E displayed the "Edit" submenu in Excel. Now, it just highlights the "Edit" menu command in the menu bar and I have to press [Enter] to siaply the Edit submenu. Could anyone offer a suggestion as to why this might be? All the other commands (File, View, Insert etc) work fine! Thanks in advance Pete -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add XML submenu | Excel Discussion (Misc queries) | |||
How to add a submenu to a submenu? | New Users to Excel | |||
SubMenu .action argument | Excel Worksheet Functions | |||
XML submenu | Excel Discussion (Misc queries) | |||
Display shading and font colors in edit mode | Excel Discussion (Misc queries) |