Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect cell formatting
Excel 2003 - I have a spreadsheet that has various cells with different types
of formatting - ie: bold / shade / font size etc. When a user copies / pastes from text from 1 cell to another, it carries over the formatting as well as the text - I want just the text to be copied. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect cell formatting
Instead of "regular" Paste - try 'PasteSpecial' Values' 'OK'
Micky "David" wrote: Excel 2003 - I have a spreadsheet that has various cells with different types of formatting - ie: bold / shade / font size etc. When a user copies / pastes from text from 1 cell to another, it carries over the formatting as well as the text - I want just the text to be copied. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect cell formatting
Yes, thank you. I was hoping for someway to "lock" the formatting, as there
are several users of this spreadsheet - some are not so computer savy. "מיכאל (מיקי) אבידן" wrote: Instead of "regular" Paste - try 'PasteSpecial' Values' 'OK' Micky "David" wrote: Excel 2003 - I have a spreadsheet that has various cells with different types of formatting - ie: bold / shade / font size etc. When a user copies / pastes from text from 1 cell to another, it carries over the formatting as well as the text - I want just the text to be copied. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect cell formatting
If you are willing to use some VBA try this event code.
Private Sub Worksheet_Change(ByVal Target As Range) 'retain formatting when a cell is copied over Dim myValue With Application .EnableEvents = False myValue = Target.Value .Undo Target = myValue .EnableEvents = True End With End Sub This is sheet code. Right-click on the sheet tab and "View code" Copy/paste the code into that sheet module. Alt + q to return to Excel. When you copy and paste, the destination formatting will be retained...........source formatting is ignored. Requires users to enable macros when opening the workbook. Gord Dibben MS Excel MVP On Sun, 20 Dec 2009 03:39:01 -0800, David wrote: Yes, thank you. I was hoping for someway to "lock" the formatting, as there are several users of this spreadsheet - some are not so computer savy. "????? (????) ?????" wrote: Instead of "regular" Paste - try 'PasteSpecial' Values' 'OK' Micky "David" wrote: Excel 2003 - I have a spreadsheet that has various cells with different types of formatting - ie: bold / shade / font size etc. When a user copies / pastes from text from 1 cell to another, it carries over the formatting as well as the text - I want just the text to be copied. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect (Lock) Cell Formatting ONLY | Excel Discussion (Misc queries) | |||
Is it possible to protect cell formatting in an unlocked cell? | Excel Discussion (Misc queries) | |||
Protect conditional formatting in destination cell | Excel Worksheet Functions | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Protect Cell Formatting | Excel Worksheet Functions |