Macro to Print to PDF the tabs between two tabs by click of button

[sherryaw]

Hi,

I am very new to the macro/VBA language world and need help writing a macro to print the tabs that are between two designated tabs to PDF. The button the macro should be assigned to is on the ADMIN tab. The tabs to print to PDF are the green tabs located between the two black tabs labeled Presentation. I've attached a dummy file because the actual file is too large to post.

Any help is appreciated!!
Thanks!

[Kenneth Hobson]

Would it always be those 3 or would it need to be dynamic and pick the ones between "Presentation -->" and "<-- Presentation"?

[sherryaw]

It will not be those three every time. It will be any tabs between the Presentation tabs. The number of tabs will vary each time.

[Kenneth Hobson]

One last question, would it be one pdf file or a pdf file for each sheet? If the former then:

Please Login or Register  to view this content.

[sherryaw]

It will be one PDF file.

Thanks!

[sherryaw]

Thank you Ken!

How can it be changed to either (1) name the PDF file the same as the workbook it is pulling the data from, or,(2) give the option to Save As, so the location/name can be determined at that time?

Thanks,
Sherry

[Kenneth Hobson]

Depends on which one you want.
As you can see from my pdf routine, passing the 3rd parameter as True meets choice (2).

Please Login or Register  to view this content.

[sherryaw]

What makes it pass as TRUE?

[Kenneth Hobson]

I guess it would be you since I can't control your computer. I showed how to do it in #7.

When passing parameter values to a routine, not all have to be passed if you see the word Optional. Optional parameters usually have a default value which in my routine is False and left out in the first code shown. Replace the line of code in the call shown in #4 with what I showed in #7.