What I have:
An Excel workbook that uses a VB macro to calculate the price of a product based on a complicated Bill of Material set of instructions.
How the workbook is designed:
The workbook has two worksheets: one with material costs and constants and the other with the product configuration. There is a button that when clicked, calculates the prices of a specific product configuration using the costs and constants in the other worksheet.
What I would like to design:
I want to be able to have a centrally-hosted Excel file/page where our sales reps can enter the product configuration, click a button and get the price of a product. However, the sales reps must NOT have access to the constants and costing page - this is a key constraint.