i always avoided using muskets for just that reason, however there is a historical battle (HRE + Spain vs France) where HRE's muskets start out lined up behind their pikes, with France about to charge your lines. If you don't move them from this position the muskets will fire THROUGH the pike ranks and decimate the french charge.