VBA: Call Macros

[AD_Taylor]

Hi,

I have a Sub which I don't want to be seen in the Run Macros window but I do want to be able to call from other Modules inside my code.

For example I want to be able to call it from a Worksheet_Change event. But I specifically don't want users to be able to see and/or run it.

I thought the way around this would be a Private Sub but then only code in the same Module can call it.

Any ideas?
- Adam

 

[Colin Legg]

Add this line to the top of the code module (the same place where you have Option Explicit):

Option Private Module

 

[Anthony47]

Then: Private AND write the macro in the same "sheet code module" that contains the Worksheet_Change macro.

Bye

 

[AD_Taylor]

Add this line to the top of the code module (the same place where you have Option Explicit):

Option Private Module

Perfect! Thanks for the answer Colin

Then: Private AND write the macro in the same "sheet code module" that contains the Worksheet_Change macro.

Bye

This would be great if i didn't want to organise my code lol. I have a lot of subs that do similar things so I've grouped them in one module - I don't think it'd be a good idea to spread them randomly all over the place just so I can call them.