Download Page: https://www.launchexcel.com/decision-matrix-download-page

Why is the Decisio Matrix file format .xlsm?
--------------------------------------------

Q: : I downloaded a criteria matrix from you that has macros. Why does it have macros?

What do they do?
Can I just keep them off?
Can I download a version without macros?

Thank you, I just want to make sure I don't download a virus.

--------------------------------------------

A: Thanks for your question about the Decision Matrix and why it is in a macro-enabled file format.

The reason for this is simple: I created one User Defined Function (UDF) in VBA that is used in the Decision Matrix.

Excel does not have a built-in function to display the Saved Date, so the UDF handles this.

The UDF is called LastSaved() and returns a string.

The UDF can be called from the Excel workbook, like in cell J2:
="Date last saved: "&TEXT(lastsaved(),"mmm-dd yyyy")

You can access the UDF code by pressing ALT + F11 to view the VBA Editor.

You can see the VBA code in the Module called "UDF"

Public Function LastSaved() As String
     LastSaved = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function

This is the only code in the workbook.

You can go back to Excel by closing the VBA Editor window (top right X or Alt + F4) or by pressing ALT + F11 to switch back to Excel.

If you prefer not to use the UDF, you can run the workbook without enabling macros.

In which case, you need to update the last saved date in cell J2 manually.

Best regards
Victor (2012)

Download Page: https://www.launchexcel.com/decision-matrix-download-page


