excel worksheet contains macros I need to distribute it "package" so people dont have to

The excel worksheet contains macros I need to distribute it as a "package," so people do not have to through the enabling macros in Excel hassle

======== More detail ===========
I have written an MSP Business Evaluator and accelerator in Excel. The user inputs their contact information and 4 financial numbers, including years in business, revenue, number of employees,?* and cost per employee.?* I determine what peer group the business is in based on revenue (in a table), provide multiple customized reports for the company, and compare the business against its peers.?* It also provides a customized roadmap to excel rate their growth to the next peer group where they increase revenue, profit, and company worth while decreasing expenses.?*?*
All of these reports are derived from a table of the 8 Peer groups, and reports are created and calculated for the individual business based on the four financial numbers the customer initially inputted.?*?*?*
My issue is that when I send the evaluator to a customer, they need to
1. download a zip file
2. open the worksheet
3, enable macros
4. change settings in the trust center
5. save the sheet
6. re-open the sheet
7. Hope for the best!!!
I use macros to control input from the user, validating phone numbers and filling all fields, and also navigate between the sheets and subscription paid and unpaid versions to determine what reports they have access to
Is there a plug-in for Excel (or a different option) to make it an executable package that everything is in a self-contained package?

It is possible to automate all of what you are seeking ... using VBA. Most of it will require that you write a few macros
to accomplish it. Here are two resources / macros that "enable macros" and another that will set the "Trust Level".



To enable macros :


http://www.vbaexpress.com/kb/getarticle.php?kb_id=578

Please Login or Register  to view this content.

To change Trust Settings :


https://www.mrexcel.com/board/thread...th-vba.631545/

Please Login or Register  to view this content.