Trevor:
If I make the sub a private one would I still be able to call codes
from diffrent modules within the same worksheet. For example my
worksheet has abt 9 modules each one dose certain things and I am
hevely calling one sub from one module or another. would I still be
able to do this going private sub.

Ardy
Trevor Shuttleworth wrote:
Ardy

a couple of ways:

you could use: Option Private Module

or

you could make each of the subroutines private: Private Sub test()

Regards

Trevor


"Ardy" wrote in message
ups.com...
Hide Macro's
Is there a possibility to hide created macros within macro window from
the users? This is to prevent users to execute out of sequence code.

Ardy