First letter after ampersand eg &Please 'P' does not show as underlined on VBA Excel 97.
What's wrong?
Thanks :blush:
Printable View
First letter after ampersand eg &Please 'P' does not show as underlined on VBA Excel 97.
What's wrong?
Thanks :blush:
No , it doesn't with Excel VBA - 2000, or 2002 either !
Seems not to work the same as VB, doesn't allow you to put 'alt + key' - functionality in !
Properties > Misc > Accellerator
Drop your key in there.
Well you learn something knew everyday hey !!
never even looked at the accelerator property before now !
Cheers Ecniv, even if it wasn't my question i am sure that will come in useful in the future !
There's also a user setting in Win2K (not sure about XP) where the underline display can be turned on or off, but nothing the app can do about that.
Yes, XP has the same feature in the OS to allow you to hide the accelerators until the Alt key is pressed.
In XP youc can change it by going to Control Panel > Display > Appearance tab > Advanced button >
Effects and check or uncheck the "Hide underline letters for keyboard navigation until I press the Alt key".
Thanks dude