After some intense researching here and on Google I have solved my issue getting Sparkfun USB Host shield to work with Leonardo which no longer has ISCP pins on D11-D13 as UNO R3 has using the new revision of USB Host shield 2.0 library. My goal was to gain control of my Canon EOS 7D
I wrote a small guide (see PDF attachment) containing a lot of photos that hopefully will help others currently experiencing the same issues I had.
Its also the first version and may contain errors misspellings
sparkfun-usb-host-shield-hack.pdf (1.23 MB)