Rearranging order of multiple sheets for printing?

[fastbiker]

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

[fastbiker]

Oh, 2 more items:

All sheets are protected except for unlocked cells (forms) and I can print preview just fine but when go to select pdf as printer I get one box to put file name and then when that starts printing to pdf another print to pdf box opens immediately...

TIA

[fastbiker]

I love it when I solve my own problems before someone replies

The problem was that I had the page setup to 'landscape' on some and 'portrait' on one. When I made them all the same it worked perfectly !!!!

Enjoy the weekend!