Hi Guys,
I developed a few formulas that I don't want to share with everybody.
Does anyone know how to hide the formulas shown inside the cells, without protecting sheet?
Once I tried and vba code but it got my workbook really slow.
Hi Guys,
I developed a few formulas that I don't want to share with everybody.
Does anyone know how to hide the formulas shown inside the cells, without protecting sheet?
Once I tried and vba code but it got my workbook really slow.
File, Options, Advanced, Un-check: show formula bar.
Not foolproof, but may take the average user some time to uncover the goods.
Edit: Just occurred to me that this fix is application driven, and not file dependent. So, never-mind.
Pete
Last edited by PeteABC123; 05-13-2020 at 11:45 AM.
They know how to use formulas in excel... I need an more effective way
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks