83K Excel 2010 spreadsheet with five page macro (VBA code). There are 2 tables, one 2x56 and the other 55x45 (3 variables: Income, # of children, age category). Data input is 4 alphanumeric fields of 1 column and 1 row, 3 rows, 8 rows, and 9 rows, 34 currency inputs, 6 integer inputs, 2 two character alphas, and 2 percentages. Input template size of 2 sheets of regular paper. Calcualtions are straight arithetic and 2 table look-ups. User opens Excel, retrieves template, fills it out, calculations are done, template updated, printed (2 page report), and saved in new Excel file for future operations. 2x56 table updated quarterly so that table must have read/write abilitiy but larger table read only.
I would like the user to only see then template but the user can make any changes to the template but cannot access the macro. I also am worried about security flags if user executes macro. Don't care if template comes from web or drive. [url removed, login to view] is competitor. Kansas Child Support Guidelines found at [url removed, login to view] This template is a proof-of-concept as new tables go into effect in November of 2011.