| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking the background so it's not wiped by cut-n-paste
Hiya,
Does anybody know how to lock a background design (grid, colours etc) so it's not moved when you cut and paste the contents of the cells, leaving plain white blank cells behind? Thanks in advance, Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking the background so it's not wiped by cut-n-paste
Can I assume this is something that can't actually be done in Excel then? :(
"Mike Halsey" wrote: Hiya, Does anybody know how to lock a background design (grid, colours etc) so it's not moved when you cut and paste the contents of the cells, leaving plain white blank cells behind? Thanks in advance, Mike |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking the background so it's not wiped by cut-n-paste
Not without using some code to store the formats then replace after the
cutting. I have no code off the top of my head to do that. Perhaps just copy and paste then come back and delete the contents. Gord Dibben MS Excel MVP On Thu, 28 Jan 2010 04:06:01 -0800, Mike Halsey wrote: Can I assume this is something that can't actually be done in Excel then? :( "Mike Halsey" wrote: Hiya, Does anybody know how to lock a background design (grid, colours etc) so it's not moved when you cut and paste the contents of the cells, leaving plain white blank cells behind? Thanks in advance, Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking Worksheets, Copy and Paste Question | Excel Worksheet Functions | |||
| Need HELP! Excel docs wiped out | Excel Discussion (Misc queries) | |||
| Help, Excel Files Being Wiped Out: Data Lost or Corrupted | Excel Worksheet Functions | |||
| how do i recover excel 2002 that was wiped of my computer | Excel Discussion (Misc queries) | |||
| copy/paste drop down boxes (forms) without locking cell link? | Excel Discussion (Misc queries) | |||
Linear Mode
