Is there a way to hide formulas other than format cell/hide then protecting sheet? I see several threads on the subject but it seems that is the only solution people recommend. That solution does not fit my needs. Can anyone help with an alternative? Thanks in advance.
-
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.
Hiding formula without protecting sheet
- Thread starter Hobie626
- Start date
-
- Tags
- format cell formulas
Macropod
Retired Moderator
- Joined
- Aug 27, 2007
- Messages
- 3,697
Hi,
If you're just trying to prevent people seeing the logic in your formulae, you could create a set of user-defined functions (UDFs) that incorporate the logic, give the UDFs obscure names and password-protect the workbook's vba project.
Cheers
If you're just trying to prevent people seeing the logic in your formulae, you could create a set of user-defined functions (UDFs) that incorporate the logic, give the UDFs obscure names and password-protect the workbook's vba project.
Cheers
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,795
- Office Version
- 365
- Platform
- Windows
Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=361685
Please do not post your question multiple times.
http://www.mrexcel.com/forum/showthread.php?t=361685
Please do not post your question multiple times.
Upvote
0
- Status
Similar threads
- Solved
