Printing PDF's

M

mcp201

I have 3 worksheets, each with watermarked names already where I want them to
appear. In a 4th worksheet, I have the names listed of the people I want to
be watermarked in each sheet. I have my print macro working fine which is
shown below. How would I be able to alter this to be able to print my
worksheets with the watermarked names to PDF??? Thanks in advance.

Sub Print_xxx_to_printer()
Dim iStart As Integer
Dim person As String

iStart = 8
person = Worksheets("Watermark").Range("F" & iStart).Value
Do While person <> ""
Worksheets("Watermark").Range("B4") = person
Worksheets("Data 1 Sheet").Select
ActiveSheet.Shapes("WordArt 17876").Select
Selection.ShapeRange.TextEffect.Text = person
ActiveSheet.Shapes("WordArt 17877").Select
Selection.ShapeRange.TextEffect.Text = person
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Worksheets("Data2 Sheet").Activate
ActiveSheet.Shapes("WordArt 26").Select
Selection.ShapeRange.TextEffect.Text = person
ActiveSheet.Shapes("WordArt 27").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Worksheets("Data3 Sheet").Activate
ActiveSheet.Shapes("WordArt 25").Select
Selection.ShapeRange.TextEffect.Text = person
ActiveSheet.Shapes("WordArt 26").Select
Selection.ShapeRange.TextEffect.Text = person
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
iStart = iStart + 1
person = Worksheets("Watermark").Range("F" & iStart).Value
Loop
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top