How to Export Excel to PDF with One Click (VBA Macro Button)💡 @ExcelCampus
How to Export Excel to PDF with One Click (VBA Macro Button)💡  @ExcelCampus
Uploaded August 2026 | Updated November 2026, 1 hour ago
Still exporting Excel reports to PDF the long way? 📊📄

Turn a simple shape into a one click PDF button using an Excel VBA macro. It’s a quick way to streamline repetitive exports, save time, and make your spreadsheets feel more professional.

Copy the VBA code below and try it yourself! 👇

Sub SaveAsPDF()
Dim filePath As Variant

filePath = Application.GetSaveAsFilename( _
FileFilter:="PDF Files (*.pdf), *.pdf")

If filePath = False Then Exit Sub

With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=filePath

MsgBox "PDF saved!"
End Sub

📌Download Free VBA Keyboard Shortcuts:
excelcampus.com/vba-shortcuts

#excel #exceltips #excelvba #vbamacro #excelautomation #exceltutorial #excelformulas #productivitytips #microsoftexcel #pdfexport
How to Export Excel to PDF with One Click (VBA Macro Button)💡Table SlicerTransform Your Data into Stunning Scorecards in Excel! 📊✨Filter FunctionHow to Add a Line Break in Excel (Easy Shortcut!)Stop Copy-Pasting. Use VSTACK!Three Formula TipsHow to Insert Clickable Files in Excel (Super Easy!) 📎✨EOMONTH: End of Month & First of MonthExcel Bad Habit #2: Stop Using Text to Columns in Excel! Use This InsteadEvent Tracking Made Easy with Excel! 🎉10 Excel Secrets That Erase Hours of Tedious Work
Excel Campus - Jon |

How to Export Excel to PDF with One Click (VBA Macro Button)💡

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER