Printing multiple worksheets as seperate PDF files

[JanetR]

How do I print several worksheets as seperate PDF files?

I have a master sheet for data entry (that doesn't need to be printed) and then multiple worksheets which need to be sent to different people but they cannot see the other worksheets. How do I print them to separate files so I don't have to print 50+ times?

I am using excel 2003.

Thanks.

 

[NBShep]

This macro worked beautifully for me, but the PDF's are smaller than my printouts. How do I limit this to my print range rather than the entire sheet?

 

[NBShep]

I changed "IgnorePrintAreas" to TRUE. It did the trick for print layout.