disable alt and control shortcut keys

J

jhahes

If I have created macros that are associated with Shortkut keys...

for instance Ctrl+b = will run macro associated with b as shortcut
key....


Is there anyway to disable all the default shortcut keys....like Ctrl+p
will bring up the print dialog box....I only want to use the shortcut
keys that my macros are assigned to...

thanks for any help
 
S

skatonni

There is information here:
http://msdn.microsoft.com/library/d...en-us/vbaxl11/html/xlmthOnKey1_HV05203370.asp

If there isn't another way it looks like it would be quite a job to disable
every one.

With Application
.OnKey "^c", "" 'Copy shortcut disabled
.OnKey "^v", "" 'Paste shortcut disabled
.OnKey "^x", "" 'Cut shortcut disabled
.OnKey "^p", "" 'Print shortcut disabled
End With

If you want them back:

With Application
.OnKey "^c" 'Copy shortcut enabled
.OnKey "^v" 'Paste shortcut enabled
.OnKey "^x" 'Cut shortcut enabled
.OnKey "^p" 'Print shortcut enabled
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top