Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a formula. Change Source data
I would like to hide a formula and be able to edit the data that feeds into
the formula. When I protect and hide the formula, the data cells can not be changed either. Help would be much appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a formula. Change Source data
By default, all cells are locked, so that when you protect the
worksheet, all cells are not editable. To get around this, select all the cells in the worksheet (click the button above the "1" row header and to the left of the "A" column header), uncheck the Protected item on the Format Cells dialog. Then, go back and choose the cells that really should be locked, set the protected status, and protect the sheet. Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Mon, 15 Feb 2010 12:23:01 -0800, wheelspk wrote: I would like to hide a formula and be able to edit the data that feeds into the formula. When I protect and hide the formula, the data cells can not be changed either. Help would be much appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a formula. Change Source data
Can you post your formula?
"wheelspk" wrote: I would like to hide a formula and be able to edit the data that feeds into the formula. When I protect and hide the formula, the data cells can not be changed either. Help would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Source Data in VBA | Excel Programming | |||
Change Source Data in VBA | Charts and Charting in Excel | |||
how do i change the data source | Excel Discussion (Misc queries) | |||
How change link source in long formula when source moved | Excel Programming | |||
Change Data Source | Excel Programming |