Hello,

I have a number of check boxes on worksheets. As I add more and mor
copies of that worksheet I am mindful of the fact that the underlyin
code for those check boxes is also copied and this will be increain
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 cod
that is held in a module?

Hope that makes sense.

thank

--
bluegn
-----------------------------------------------------------------------
bluegnu's Profile: http://www.excelforum.com/member.php...fo&userid=3610
View this thread: http://www.excelforum.com/showthread.php?threadid=56015

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

thanks


--
bluegnu
------------------------------------------------------------------------
bluegnu's Profile: http://www.excelforum.com/member.php...o&userid=36108
View this thread: http://www.excelforum.com/showthread...hreadid=560153