I want fully protect my formula,
1, i dont want allow to copy my formula,
2, i want hide my formula in formula bar,
3, protect formula from others to edit
i want allow only a2 to a10 cells to edit, all others should be locked,
note : I already locked other cells, but its allow to copy my formula, and view my formula in formula bar,
so its waste of time to lock. Any other solution?
See attached file.
Password is vv
Highlight your range with your formula>format cell>>protection>tick the hide option. Then protect your sheet again.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Than you so much dear buddy....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks