|
About protection of Cells
I have a problem in the spreadsheet with few many data with conditional
formats.Each cell has different conditional format.When a cell is copied from one to another the format is getting copied.How to protect the cells without copying the conditional format?Is there any way to protect only the conditional formatting of the cell but not the normal formatting? -- Ruby |
About protection of Cells
Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste!
Regards, Stefi Ruby ezt *rta: I have a problem in the spreadsheet with few many data with conditional formats.Each cell has different conditional format.When a cell is copied from one to another the format is getting copied.How to protect the cells without copying the conditional format?Is there any way to protect only the conditional formatting of the cell but not the normal formatting? -- Ruby |
About protection of Cells
-- Ruby "Stefi" wrote: Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste! Regards, Stefi Hi Thanks for ur reply.If i am handling this worksheet,i can do this,but the persons who are handling these worksheet is not that familiar in english or excel. To avoid them getting confused i am looking for a permanent solution. Ruby ezt *rta: I have a problem in the spreadsheet with few many data with conditional formats.Each cell has different conditional format.When a cell is copied from one to another the format is getting copied.How to protect the cells without copying the conditional format?Is there any way to protect only the conditional formatting of the cell but not the normal formatting? -- Ruby |
About protection of Cells
You might write some simple macros for them assigned to hotkeys!
Stefi Ruby ezt *rta: -- Ruby "Stefi" wrote: Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste! Regards, Stefi Hi Thanks for ur reply.If i am handling this worksheet,i can do this,but the persons who are handling these worksheet is not that familiar in english or excel. To avoid them getting confused i am looking for a permanent solution. Ruby ezt *rta: I have a problem in the spreadsheet with few many data with conditional formats.Each cell has different conditional format.When a cell is copied from one to another the format is getting copied.How to protect the cells without copying the conditional format?Is there any way to protect only the conditional formatting of the cell but not the normal formatting? -- Ruby |
About protection of Cells
Hi Stefi,
Thanks for ur reply.Could u please tell me how to create macros with conditional formatting.I tried to create one but i am unable to do it. Thanks -- Ruby "Stefi" wrote: You might write some simple macros for them assigned to hotkeys! Stefi Ruby ezt *rta: -- Ruby "Stefi" wrote: Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste! Regards, Stefi Hi Thanks for ur reply.If i am handling this worksheet,i can do this,but the persons who are handling these worksheet is not that familiar in english or excel. To avoid them getting confused i am looking for a permanent solution. Ruby ezt *rta: I have a problem in the spreadsheet with few many data with conditional formats.Each cell has different conditional format.When a cell is copied from one to another the format is getting copied.How to protect the cells without copying the conditional format?Is there any way to protect only the conditional formatting of the cell but not the normal formatting? -- Ruby |
About protection of Cells
Here is an example which copies the content of the active cell in cell of
same row, next column: Sub testcopy() ActiveCell.Copy Cells(ActiveCell.Row, ActiveCell.Column + 1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False End Sub Insert it in a normal module and assign a hotkey to it (ToolsMacroMacros or Directly Alt-F8)Options (maybe the buttons name is different, I translate it back from a national language version, it's the bottommost button on the gialog box). Please give more details on what to copy and where to copy, if you want a more specific sub! Regards, Stefi Ruby ezt *rta: Hi Stefi, Thanks for ur reply.Could u please tell me how to create macros with conditional formatting.I tried to create one but i am unable to do it. Thanks -- Ruby "Stefi" wrote: You might write some simple macros for them assigned to hotkeys! Stefi Ruby ezt *rta: -- Ruby "Stefi" wrote: Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste! Regards, Stefi Hi Thanks for ur reply.If i am handling this worksheet,i can do this,but the persons who are handling these worksheet is not that familiar in english or excel. To avoid them getting confused i am looking for a permanent solution. Ruby ezt *rta: I have a problem in the spreadsheet with few many data with conditional formats.Each cell has different conditional format.When a cell is copied from one to another the format is getting copied.How to protect the cells without copying the conditional format?Is there any way to protect only the conditional formatting of the cell but not the normal formatting? -- Ruby |
About protection of Cells
-- Ruby "Stefi" wrote: Here is an example which copies the content of the active cell in cell of same row, next column: Sub testcopy() ActiveCell.Copy Cells(ActiveCell.Row, ActiveCell.Column + 1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False End Sub Insert it in a normal module and assign a hotkey to it (ToolsMacroMacros or Directly Alt-F8)Options (maybe the buttons name is different, I translate it back from a national language version, it's the bottommost button on the gialog box). Please give more details on what to copy and where to copy, if you want a more specific sub! Regards, Stefi Ruby ezt *rta: Hi Stefi, Thanks for ur reply.Could u please tell me how to create macros with conditional formatting.I tried to create one but i am unable to do it. Thanks -- Ruby "Stefi" wrote: You might write some simple macros for them assigned to hotkeys! Stefi Ruby ezt *rta: -- Ruby "Stefi" wrote: Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste! Regards, Stefi Hi Thanks for ur reply.If i am handling this worksheet,i can do this,but the persons who are handling these worksheet is not that familiar in english or excel. To avoid them getting confused i am looking for a permanent solution. Ruby ezt *rta: I have a problem in the spreadsheet with few many data with conditional formats.Each cell has different conditional format.When a cell is copied from one to another the format is getting copied.How to protect the cells without copying the conditional format?Is there any way to protect only the conditional formatting of the cell but not the normal formatting? -- Ruby |
About protection of Cells
-- ??? Does it mean anything?
Stefi Ruby ezt *rta: -- Ruby "Stefi" wrote: Here is an example which copies the content of the active cell in cell of same row, next column: Sub testcopy() ActiveCell.Copy Cells(ActiveCell.Row, ActiveCell.Column + 1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False End Sub Insert it in a normal module and assign a hotkey to it (ToolsMacroMacros or Directly Alt-F8)Options (maybe the buttons name is different, I translate it back from a national language version, it's the bottommost button on the gialog box). Please give more details on what to copy and where to copy, if you want a more specific sub! Regards, Stefi Ruby ezt *rta: Hi Stefi, Thanks for ur reply.Could u please tell me how to create macros with conditional formatting.I tried to create one but i am unable to do it. Thanks -- Ruby "Stefi" wrote: You might write some simple macros for them assigned to hotkeys! Stefi Ruby ezt *rta: -- Ruby "Stefi" wrote: Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste! Regards, Stefi Hi Thanks for ur reply.If i am handling this worksheet,i can do this,but the persons who are handling these worksheet is not that familiar in english or excel. To avoid them getting confused i am looking for a permanent solution. Ruby ezt *rta: I have a problem in the spreadsheet with few many data with conditional formats.Each cell has different conditional format.When a cell is copied from one to another the format is getting copied.How to protect the cells without copying the conditional format?Is there any way to protect only the conditional formatting of the cell but not the normal formatting? -- Ruby |
| All times are GMT +1. The time now is 11:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com