I want to hide the formula's which I have done, so that no one ca.
I want to hide the formula's which I have done, so that no one can see, but
they can edit the same sheet or workbook |
You will need to unlock the cells you want people to change and lock and
hide the ones with your formulas, format, cells, protection, then protect the worksheet, tools, protection, protect sheet. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Excel General Question" <Excel General wrote in message ... I want to hide the formula's which I have done, so that no one can see, but they can edit the same sheet or workbook |
If you want the user to be able to edit the worksheet, they'll have
access to the formulae. There's no way to prevent that. Even if you protect the worksheet so that the formulae are hidden, anyone who can find these groups can find ways to bypass the protection in a few seconds: http://www.mcgimpsey.com/excel/removepwords.html In article , "Excel General Question" <Excel General wrote: I want to hide the formula's which I have done, so that no one can see, but they can edit the same sheet or workbook |
All times are GMT +1. The time now is 06:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com