Using Modules?

[bluegnu]

Hello,

I have a number of check boxes on worksheets. As I add more and more copies of that worksheet I am mindful of the fact that the underlying code for those check boxes is also copied and this will be increaing the size of my file.

Should I have that code in a module and simply call it from each sheet? I've tried to do this, but I can't get it to work! How do you use code that is held in a module?

Hope that makes sense.

thanks

[bluegnu]

I've worked this out now. Needed to use Public Sub and ActiveSheet to get it to work.

thanks