Disabling shift keypress that prevents code execution
This cannot be done with VBA. In my opinion, this should
not be done, period. Taking control away from your users
is bad mojo. A definite no-no.
If you absolutely must have macros enabled for your
workbook to function correctly, add a worksheet explaining
that fact and have it be the only sheet not set to
xlSheetVeryHidden. In your workbook_open routine, place
code that reverses these settings and continue on your
merry way.
Happy day to you!
Quote:
>-----Original Message-----
>How can I prevent a user from using the shift key to
prevent VBA code
>from running when a workbook is opening?
>.
