VBA to create multipage pdf one page at a time and do something in between

Hoping someone here can help me write a routine that would create a multipage pdf from one print range. this would be written onto a command button.

I have a worksheet with several charts. this worksheet also has a scrollbar that scrolls through the x-axis range on all the charts.
Basically i want to pdf the print range of this worksheet several times to end up with one pdf in the end...but change the scroll bar value in between each page print.
Essentially:
-set scrollbar value to minimum
-pdf the page
-increase scrollbar value by .LargeChange
-pdf the page
-increase scrollbar value by .LargeChange
-pdf the page
...do this until scrollbar value is maximum and then have the window popup that prompts user for the file name & save location of the final pdf.

I hope this makes sense.

Possibly this may work for you...

Please Login or Register  to view this content.

Thank you!

Unfortunately, I got slammed at work and have not had time to implement and test this out.
I will report back on my success or failure as soon as I can.

Thank you again for your response!