Excel Menu Key
Apparently, I've never before tried to enter a slash in an Excel sheet until now.
Because the result surprised me - if you type /, it doesn't enter the character in the cell, but it activates the keyboard access to the Excel menu. Which is really annoying if you actually want to enter / in a cell.
Fortunately, this behavior can be turned off and this is how:
Excel 2007
1. From the Office Button menu, press the button Excel Options.
2. Choose Advanced, and then scroll down until you see the Lotus compatibility section.
3. In the field Microsoft Office Excel menu key, replace the slash with a character that you do not use frequently or delete it, and then click OK.
Excel 2003
1. From the Tools menu, select Options
2. Select the tab Transition
3. In the field Microsoft Office Excel menu key, replace the slash with a character that you do not use frequently or delete it, and then click OK.
And to make this a post about VBA, you can switch off this property in VBA as follows:
Application.TransitionMenuKey = ""
Because the result surprised me - if you type /, it doesn't enter the character in the cell, but it activates the keyboard access to the Excel menu. Which is really annoying if you actually want to enter / in a cell.
Fortunately, this behavior can be turned off and this is how:
Excel 2007
1. From the Office Button menu, press the button Excel Options.
2. Choose Advanced, and then scroll down until you see the Lotus compatibility section.
3. In the field Microsoft Office Excel menu key, replace the slash with a character that you do not use frequently or delete it, and then click OK.
Excel 2003
1. From the Tools menu, select Options
2. Select the tab Transition
3. In the field Microsoft Office Excel menu key, replace the slash with a character that you do not use frequently or delete it, and then click OK.
And to make this a post about VBA, you can switch off this property in VBA as follows:
Application.TransitionMenuKey = ""