In this publication titled how to save selected sheets in excel as pdf, I have provided a complete image from start to finish ,Please look below
