shortcut key and Alt F8

[tim963]

I have some Marcos with a “shortcut key” assigned to them, is there any way to not have them show up when I do Alt F8? I know you can put private in front of the sub, but when I do the “shortcut key” will not work. Excel ’97. Thanks

 

[Von Pookie]

Not that I'm aware, sorry. ::shrug::

 

[Joe Was]

From the VBA editor, select: Tools-VBAProject-Project Properties, Protection, then:

Check "Lock"
Type your password
Close the editor.
Save the workbook.

The next time you open your workbook,
if you hit Alt-F8, your macros will show up but will not be available for "Edit" if you view code you must type the password to work in the editor.

This will lock most users out of your code. JSW

 

[tim963]

Joe, I don’t need to lock the project from editing , I want to be able to use the shortcut keys but not see the Marco with Alt F8, as stated by Von Pookie above this might not be possible

 

[Mark O'Brien]

If all you want to do is disable that shortcut combo, you can put this code in your workbook module:

<pre>

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "%{F8}"
End Sub

Private Sub Workbook_Open()
Application.OnKey "%{F8}", ""
End Sub</pre>

HTH

 

[Juan Pablo González]

Another (Untested) option, put<pre>Option Private Module</pre>
at the top of the module.

_________________
Regards,

Juan Pablo G.
MrExcel.com Consulting
This message was edited by Juan Pablo G. on 2002-10-04 15:53

 

[tim963]

Juan, Option Private Module want let the shortcut keys work

 

[Juan Pablo González]

No, It won't... sorry....

 

[Ivan F Moala]

On 2002-10-04 16:08, tim963 wrote:
Juan, Option Private Module want let the shortcut keys work

Have you tried Marks suggestion ?

 

[tim963]

I don’t want to disable the Alt F8 combo because there are Marco in the personal folder that need to be run sometime