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

: For business tax compliance (like GST), you can often download standardized Excel-based invoice formats directly from government GST portals . Pro-Tips for Professionalism:

: 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

Sub SaveInvoiceAsPDF() Dim FileName As String Dim Path As String ' Define where to save (e.g., your Desktop or a specific folder) Path = "C:\Users\YourName\Downloads\" ' Create file name using cell values (e.g., Cell B1 is Invoice #, Cell B2 is Name) FileName = Range("B1").Value & "_" & Range("B2").Value & ".pdf" ' Export the active sheet ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=Path & FileName MsgBox "Invoice Saved to: " & Path & FileName End Sub Use code with caution. Copied to clipboard