View the model
Download the model

This Workbook contains a macro that illustrates how the WB optimizer can be called repeatedly from VBA to do sensitivity analysis. When you click on "Run Looping Macro" the VBA code will increment the Profit/Unit of Product 2 from 45-60, solve the model at each step,and copy the Total Profit and Quantity Produced of Products 1-6 to a table, and repeat.