OnKey mit Zahlen ?
19.09.2004 14:10:36
Mnauel
Ich habe mal wieder ein Problem.
Ich habe folgenden Code:
Private Sub Workbook_Open()
Application.OnKey "^{a}", ""
Application.OnKey "^{b}", ""
Application.OnKey "^{d}", ""
Application.OnKey "^{e}", ""
Application.OnKey "^{f}", ""
Application.OnKey "^{g}", ""
Application.OnKey "^{h}", ""
Application.OnKey "^{i}", ""
Application.OnKey "^{j}", ""
Application.OnKey "^{k}", ""
Application.OnKey "^{l}", ""
Application.OnKey "^{m}", ""
Application.OnKey "^{n}", ""
Application.OnKey "^{o}", ""
Application.OnKey "^{p}", ""
Application.OnKey "^{q}", ""
Application.OnKey "^{r}", ""
Application.OnKey "^{s}", ""
Application.OnKey "^{t}", ""
Application.OnKey "^{u}", ""
Application.OnKey "^{w}", ""
Application.OnKey "^{y}", ""
Application.OnKey "^{z}", ""
Application.OnKey "^{1}", ""
Application.OnKey "^{2}", ""
Application.OnKey "^{3}", ""
Application.OnKey "^{4}", ""
Application.OnKey "^{5}", ""
Application.OnKey "^{6}", ""
Application.OnKey "^{7}", ""
Application.OnKey "^{8}", ""
Application.OnKey "^{9}", ""
End Sub
Das heisst, das Alle Buchstaben und Zahlen, ausser "x", "c" und "v" deaktiviert sein sollen.
das mit den Buchstaben klappz ja super, aber das mit den Zahlen will überhaupt nicht.
Kann mir einer sagen warum nicht?
Geht dass üebrhaupt?
Wenn nicht mit der OnKey-Funktion, womit dann?
Wäre über Hilfe sehr erfreut.
Schönen Sonntag noch..
Manuel