I have a large number (100) speedsheets which are all similar and make use of
the same vba code for data entry. I dont want to include the code in each
sheet (in case I need to modify it) So the code is in a separate sheet

If I make this an addin then it loads even if the user is doing something
else and doesn't need my code.

If I put a button on a bar or create a keyboard short cut then similarly
this is always available even when not needed

So what is the proper way to have code load automatically and be accesible
when one of my sheets is loaded, but not otherwise.

Many Thanks

--
Patrick