I was glancing at Ken's article on "Printing Worksheets To A PDF File" which is kinda what I am needing to do. I am just learning bits of VBA as I go, so I dont have a great understanding, but I get by.

I have a Chart Sheet that I have coded to work with a scrollbar control which enables me to quickly go thru the graph pages by changing the x-axes scale values. I was hoping someone could help me with modifing the code for pdf printing to get all the graph pages into a multiple pdf file via a button that I have on the Chart Sheet. I am running 2003, but I have some 2010 users as well.

I tried to add the link for the article, but apparently I can't do links yet since this is my first post.

Thank you for your time,