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


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=570935

There is information he
http://msdn.microsoft.com/library/de...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

"jhahes" wrote:


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


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=570935