Hide Formulas when others will know the protected password

[HobbesIsReal]

I am creating a spreadsheet that I will be sharing with another company that will cross reference both of lines of products. I want to hide the formulas I developed but at least a few employees at the other company will have the password for the protected spreadsheet as well.

Is there a way to hide the formulas from those that have the protected password as well?

 

[Michael M]

I think you will only be able to do that by running the formulas via VBA then converting the formulas back to values in the workbook

 

[HobbesIsReal]

I am not the best at writing original VBA. Some of my formulas are several layers deep If statements that include xlookups and various rounding criteria. Is there a formula to VBA tool that could translate a formula to VBA?

 

[Michael M]

Most times aformula is pretty straightforward the same....but any quotes within a formula need to be doubled with VBA.
Maybe post a couple fo formulas so we can take a look

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Hide Formulas when others will know the protected password
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.