ben,

ben wrote:
Thank you for your suggestion, that will work with regular modules
but not with activex controls with that code assigned, "Procedure
Decleration does does not match description of event or procedure
having the same name."

What exactly are you talking about here? Are you talking about hiding the
built-in event subroutines like those exposed by ThisWorkbook or worksheet
modules? Those should be hidden by default. If they aren't, that means
someone switched them to Public, in which case you should switch them back
to Private. If you have code from other modules calling those event
subroutines directly, you have bigger problems than users being able to see
them in the Run Macro dialog. Consider moving the code from those event
subroutines to public subroutines or functions, which you can then call both
from the event routines and other modules.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]