rwmill9716
Active Member
- Joined
- May 20, 2006
- Messages
- 493
- Office Version
- 2013
- Platform
- Windows
Is there a way to hide formula? I would like to give an Excel sheet to others, but I would like to keep the formulas proprietary.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Another Question about Formula
- Thread starter rwmill9716
- Start date
-
- Tags
- formula
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
Welcome to the Board!
Under Format-->Cells-->Protection you have the option to Lock and/or Hide cells when the sheet is protected. If you choose Locked the cell in question won't be editable. If you choose Hidden, the cell's underlying formula won't be viewable, but the cell's contents will be.
Hope that helps,
Under Format-->Cells-->Protection you have the option to Lock and/or Hide cells when the sheet is protected. If you choose Locked the cell in question won't be editable. If you choose Hidden, the cell's underlying formula won't be viewable, but the cell's contents will be.
Hope that helps,
Upvote
0
