From Xlsm — Download Invoice
If you are looking to download a new template that already has these macro features:
: Press Alt + F11 , insert a New Module, paste the code, and then insert a "Button" (from the Developer tab) on your sheet to link to this macro. 3. Finding Pre-Built .xlsm Invoice Templates Download Invoice From xlsm
: Press Ctrl + P , and under the Printer dropdown, select "Microsoft Print to PDF" . This lets you "print" the file directly to your downloads folder as a PDF. 2. The One-Click Way (VBA Automation) If you are looking to download a new
: Never send the original .xlsm file to a client. It’s less professional and may trigger security warnings due to the macros. Always convert it to a PDF first. Create estimates and invoices - Microsoft Support This lets you "print" the file directly to
: Before exporting, highlight your invoice area and go to Page Layout > Print Area > Set Print Area . This prevents extra blank pages or random gridlines from appearing in your download.
: Go to File > Export > Create PDF/XPS . This ensures your client gets a clean, non-editable document.


(3 votes, average: 3.33 out of 5)