Disable Ctrl and/or Alt Key

  • Thread starter Thread starter Danny
  • Start date Start date
Because I lend a lot of my worksheets. I don't want the
users to over ride the macro commands with shortcut keys.
I tried using OnKey method but I have to write a macro for
each shortcut. So I thought, the easiest way to do it is
to have a macro command to temporary disable these keys
when they are using my worksheets.
 
Just a guess, but I think he wants to limit the ability of the foolish,
error-prone users of his spreadsheet.

There's someone who is always posting questions here in worksheet.functions
about how to disable this or that. Maybe it's this guy, but whoever it was,
he should try asking in excel.programming because there aren't formulas that
will disable keys or toolbar functions.
 
Because I lend a lot of my worksheets. I don't want the
users to over ride the macro commands with shortcut keys.
I tried using OnKey method but I have to write a macro for
each shortcut. So I thought, the easiest way to do it is
to have a macro command to temporary disable these keys
when they are using my worksheets.
Click to expand...
...

In other words, you want to force your own interface on your helpless users and
allow them no means whatsoever of modifying it to suit their needs or
preferences.

There are Windows API calls to trap any keystroke combination, and there are
other Windows API calls to detect which application should be receiving those
keystrokes. It's possible (but *VERY* difficult) to intercept certain keystrokes
for a particular application using a Windows service.

As for any way to do this in Excel itself, you'd need to use macros even to
attempt it, and macros are easy to disable. So, no, there's not secure way to do
this in Excel itself.

Wisdom comes from learning how to accomodate an existing design. All too often
that wisdom is only gained from failed attempts to supercede existing designs.
 
Back
Top