I have plugged in any number of variations to search this issue and finding none so far figured I'd post...
I have the following Workbook_Open routine, which is part of a macro file that opens from the XLSTART folder. The first three application.onkey assignments don't work; everything else does. I've changed the order of the lines; I've changed the order of ^ and %; I've changed the event to things like Workbook_Activate, Auto_Open, etc. Same results. (All the routines I'm calling reside withing the same module of the macro file.)
If I go into the code and play the routine manually, everything works fine.
I have two other macro files that opens from XLSTART that successfully make all sorts of automatic shortcut key assignments to CTRL+SHIFT and CTRL+ALT. So I'm completely lost as to why these three, specifically, won't work automatically and yet will work manually ???
Private Sub Workbook_Open()
application.OnKey "^%/", "ListWorksheetNames"
application.OnKey "^%h", "HiddenSheetForm"
application.OnKey "^%u", "Unhidesheets"
application.OnKey "^k", "Essbase_Lock"
application.OnKey "^l", "Essbase_Send"
application.OnKey "^r", "Essbase_Retrieve"
Call UnhideSheetsAddIn
End Sub
PS -- I am running Office10.
Bookmarks