All the chromatic chords discussed elsewhere on this site can be used without modulating. The extract below is in G major and - despite many accidentals - does not modulate at any point. The accidentals are instead the result of two chromatic chords as discussed in the table below the example.
the first three bars are an embellishment of a neapolitan sixth - this is the only triad based on the scale of Ab major and there is no perfect cadence in this key, so the music has not modulated
the fourth bar contains a diminished seventh chord - as discussed in chromatic chords chromatic chord often intensify rather than changes key, the resolution of the neapolitan onto V is intensified by the diminished seventh
information and orientation as you browse around TonalityGUIDE.com