protect a macro

[kwiklearner]

How can I protect a public sub from being called using alt+F8?

[Greg Wilson]

Declare "Option Private Module" at the top of the code module.

Regards,
Greg

"kwiklearner" wrote:

>
> How can I protect a public sub from being called using alt+F8?
>
>
> --
> kwiklearner
> ------------------------------------------------------------------------
> kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
> View this thread: http://www.excelforum.com/showthread...hreadid=527862
>
>

[kwiklearner]

this worked perfectly.... thanks again!