Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
mass changes to cell protection
Is there a way to alter the cell protection based on a condition instead of
going in and manually changing them? more exact: I want to protect all my cells that have a formula, and un-protect the ones that do not. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
mass changes to cell protection
Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit,
go to, special, check formulas ok, then protect the cells that are selected -- 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 "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message . .. Is there a way to alter the cell protection based on a condition instead of going in and manually changing them? more exact: I want to protect all my cells that have a formula, and un-protect the ones that do not. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
mass changes to cell protection
Paul:
I am using Excel97 (probably should have mentioned that) will they still work for me? I did try, but <CTRLA did not do anything, and I do not know where the "Special" feature is. Adam "Paul B" wrote in message ... Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit, go to, special, check formulas ok, then protect the cells that are selected -- 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 "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message . .. Is there a way to alter the cell protection based on a condition instead of going in and manually changing them? more exact: I want to protect all my cells that have a formula, and un-protect the ones that do not. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
mass changes to cell protection
Adam
Hold CTRL key down and hit the "a" key on keyboard. Alternative.....click on the gray rectangle at top left corner of the row and column headers. Either method will select all cells. FormatCellsProtection. Change to "unlocked" by clicking the checkmark out of the option box. OK out. Hit F5SpecialFormulasOK All cells with formulas are selected. FormatCellsProtection. Changed to "Locked". OK out. Now ToolsProtectionProtect sheetOK Give a password or not. Gord Dibben Excel MVP On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger" wrote: Paul: I am using Excel97 (probably should have mentioned that) will they still work for me? I did try, but <CTRLA did not do anything, and I do not know where the "Special" feature is. Adam "Paul B" wrote in message ... Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit, go to, special, check formulas ok, then protect the cells that are selected -- 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 "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message . .. Is there a way to alter the cell protection based on a condition instead of going in and manually changing them? more exact: I want to protect all my cells that have a formula, and un-protect the ones that do not. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
mass changes to cell protection
Thanks for the step-by, it cleared up my haze.
Adam Kroger: Excel MoLC < More or Less Confused ;-) "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Adam Hold CTRL key down and hit the "a" key on keyboard. Alternative.....click on the gray rectangle at top left corner of the row and column headers. Either method will select all cells. FormatCellsProtection. Change to "unlocked" by clicking the checkmark out of the option box. OK out. Hit F5SpecialFormulasOK All cells with formulas are selected. FormatCellsProtection. Changed to "Locked". OK out. Now ToolsProtectionProtect sheetOK Give a password or not. Gord Dibben Excel MVP On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger" wrote: Paul: I am using Excel97 (probably should have mentioned that) will they still work for me? I did try, but <CTRLA did not do anything, and I do not know where the "Special" feature is. Adam "Paul B" wrote in message ... Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit, go to, special, check formulas ok, then protect the cells that are selected -- 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 "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message . .. Is there a way to alter the cell protection based on a condition instead of going in and manually changing them? more exact: I want to protect all my cells that have a formula, and un-protect the ones that do not. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
mass changes to cell protection
Thanks for the feedback Adam
Gord On Thu, 24 Nov 2005 14:41:11 -0600, "Adam Kroger" wrote: Thanks for the step-by, it cleared up my haze. Adam Kroger: Excel MoLC < More or Less Confused ;-) "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Adam Hold CTRL key down and hit the "a" key on keyboard. Alternative.....click on the gray rectangle at top left corner of the row and column headers. Either method will select all cells. FormatCellsProtection. Change to "unlocked" by clicking the checkmark out of the option box. OK out. Hit F5SpecialFormulasOK All cells with formulas are selected. FormatCellsProtection. Changed to "Locked". OK out. Now ToolsProtectionProtect sheetOK Give a password or not. Gord Dibben Excel MVP On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger" wrote: Paul: I am using Excel97 (probably should have mentioned that) will they still work for me? I did try, but <CTRLA did not do anything, and I do not know where the "Special" feature is. Adam "Paul B" wrote in message ... Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit, go to, special, check formulas ok, then protect the cells that are selected -- 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 "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message . .. Is there a way to alter the cell protection based on a condition instead of going in and manually changing them? more exact: I want to protect all my cells that have a formula, and un-protect the ones that do not. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
cell protection | Excel Discussion (Misc queries) | |||
Cell protection in Excel is lost when file is uploaded to website. | Excel Discussion (Misc queries) | |||
Sheet protection in mass?! | New Users to Excel |