Greets, first post.

I have a workbook with several sheets. My ultimate goal is to have a custom button that prints only 2 or 3 sheets to a pdf file, but changes the order of them.

One of the sheets is text only, and I have been trying to record a macro where I rearrange the order of the sheets by dragging one of them and then ctrl-select the ones I want to print to pdf. The problem is that excel tries to create 2 pdfs- one with the text sheet only and the other one contains the other 2 sheets.

I'm very new to macros. Any help is greatly appreciated!

Andrew