run macros with permissions management

[srahnama]

I’m trying to figure out permissions on a pricebook application developed in Excel, and here’s the situation:
- The application is an excel file with a number of visible worksheets and a number of hidden worksheets
- The hidden worksheets contain the core pricing which are used to product the total price in the visible worksheets
- The file walks the user through a number of input tabs, and runs Macros to determine what options are available and what inputs are needed based on the solution that the user builds.

I don’t want this pricebook to work outside of my organization, to prevent people from forwarding to competitors, so I’ve locked it up with passwords, but those are easy to crack.

I’m now trying the permissions management, but the issue is that:
- In order for macros to run on the file (based on event triggers), the user seems to need “Full Control”
- If the user has “Full Control,” they can remove the permissions management restrictions, and then forward outside the organization, so that is not acceptable.

Is there a way for Macros to run on an excel file with credential management enabled, without giving the user Full Control.

Excel version is 2010.