mods in campain, doable?

I tried to insert a simple mod to limit the map zoom level in campaigns but it is not working.  So can mods be added to campain play and if so how? I put my mod into ..MODS/Campaign directory, mod works fine in the Game directory