Problem With Macros

[TooZippy]

I have two spreadsheets in one file that are identical. In one spreadsheet I highlighted an area and named it "abc". I created a macro in this spreadsheet to print area "abc" to my printer and called it "printabc". In my second spreadsheet in the same file I highlighted a similar area and named it "def". I created a macro in that spreadsheet to print area "def" to a .pdf file on my computer and called it "savedef".

When I click on the "Form Control" icon on either spreadsheet to run each macro it prints both spreadsheets to the printer. It seems that the "savedef" macro is overrun. I made sure that I Assigned the right macro to the right spreadsheet. When I edit either of the macros they both look identical. Any suggestions to get one of them to print to the printer and the other to print a .pdf file to my computer?

Thank you,

 

[Logit]

.

Option Explicit


Sub SveRngPDF()
Sheets("Sheet1").Range("A1:K16").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    "C:\Users\My\Desktop\Sheet1.pdf", Quality:= _
    xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
    OpenAfterPublish:=True
End Sub

The above code saves the Range ("A1:K16") of Sheet 1 as a PDF file, to the desktop and names it Sheet1.pdf.

You will need to edit the sheet name (if different) and the path where to save and name the file.

 

[TooZippy]

Logit, Thank you for the Code. I copied and pasted it into my file, but I get the error message "Compile error: Ambiguous name detected: SveRngPDF". I tried to run it after I changed the range, file name, path and sheet name and I got the error message. Any suggestions???

Thank you

 

[MARK858]

That message normally means you have 2 macro's with the same name.

 

[Michael M]

You can't have more than one macro with the same name....remove or rename one of them.

 

[TooZippy]

That message normally means you have 2 macro's with the same name.

I fixed the problem. I deleted all print macros and I am just using print to .pdf tile macros for my spreadsheets and it is working. Thank you,