Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show value but hide function
Hi,
I have a macro the works great and does a lot. Now I want some cells to show the results I got but hide the functions and calculations behind them. As of now if someone clicks on the cell they can see the formula that was used to get the result. I was them to only see the result and not be able to see (or change) the formula. Is there any way to do this? -Idan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
show value but hide function
Hi Idan
First go menu Format Cells, Protection section. Choose Locked and also Hidden. Now protect the sheet with Tools Protection Protect worksheet. There are quite a few things a user can't do in a protected sheet, but this is the only way to protect your cell. HTH. Best woishes Harald skrev i melding oups.com... Hi, I have a macro the works great and does a lot. Now I want some cells to show the results I got but hide the functions and calculations behind them. As of now if someone clicks on the cell they can see the formula that was used to get the result. I was them to only see the result and not be able to see (or change) the formula. Is there any way to do this? -Idan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
show value but hide function
Hello There is a way indeed. You need to use the Tools/Protection/Protect sheet (or workbook) option. This will then prevent anyone changing anything. In order to hide the formulae you need to select the cell in question and under the Format/Cells/Protection select "hidden". This means that when you protect the worksheet the formula will be hidden. Even though it is invisible it can still be deleted so you shoudl also check the "locked" option next to the "hidden" option and then people will not be able to change anything either. By default, every cell is set up with "Locked" in a speadsheet so that when you activate protection nothing may be changed. If you need to allow input into certain cells by the user then you should select those cells and uncheck the "locked" option. Of course if you want someone to be able to enter in more cells than not then you can select the whole sheet, deselect "locked" for everything and then simply reselct "locked" for the few cells in question. Clear? Good luck -- Craig_Richards ------------------------------------------------------------------------ Craig_Richards's Profile: http://www.excelforum.com/member.php...o&userid=21936 View this thread: http://www.excelforum.com/showthread...hreadid=565180 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
show value but hide function
Thanks!
Craig_Richards wrote: Hello There is a way indeed. You need to use the Tools/Protection/Protect sheet (or workbook) option. This will then prevent anyone changing anything. In order to hide the formulae you need to select the cell in question and under the Format/Cells/Protection select "hidden". This means that when you protect the worksheet the formula will be hidden. Even though it is invisible it can still be deleted so you shoudl also check the "locked" option next to the "hidden" option and then people will not be able to change anything either. By default, every cell is set up with "Locked" in a speadsheet so that when you activate protection nothing may be changed. If you need to allow input into certain cells by the user then you should select those cells and uncheck the "locked" option. Of course if you want someone to be able to enter in more cells than not then you can select the whole sheet, deselect "locked" for everything and then simply reselct "locked" for the few cells in question. Clear? Good luck -- Craig_Richards ------------------------------------------------------------------------ Craig_Richards's Profile: http://www.excelforum.com/member.php...o&userid=21936 View this thread: http://www.excelforum.com/showthread...hreadid=565180 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show zero value but hide NA | Charts and Charting in Excel | |||
Show/Hide | Excel Discussion (Misc queries) | |||
show hide row if | Excel Discussion (Misc queries) | |||
Show and Hide in Datafield | Excel Discussion (Misc queries) | |||
Hide and show | Excel Programming |