If you run your VBA code with calculations that affect any cells on your workbook sheets, it is good practice to disable some Excel services to increase the speed of the calculation.
In spreadsheets with lots of numbers, sometimes it is useful to see what cells are formulas and what numbers are just hard-defined.
Black-Scholes-Merton (or BSM) model is the most popular and widely-used option pricing model. Below, there is an example of the calculation of the BSM option price and option Greeks in Excel.