Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

https://1drv.ms/x/s!AkdZJvCClePmhFXxVeGO8m0FDILD?e=5Xe3y9

drive link

spelling mistake.

Private Sub Workbook_Beforeclose(cancle As Boolean)

Sheet1.cells.CheckSpelling

End Sub

pdf form.

Sub SaveActiveSheetsAsPDF()

'Create and assign variables

Dim saveLocation As String

saveLocation = "C:\Users\marks\OneDrive\Documents\myPDFFile.pdf"

'Save Active Sheet(s) as PDF ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=saveLocation

End Sub