![]() |
|
#1
|
|||
|
|||
|
Hello everyone,
Does anybody know of a way to lock an Excel document's layout so that when someone copy/pastes or click/drags cells around, they don't move the borders and shading with the cell's content? I have a sort of weekly-planner thing that a bunch of people have access to. They go in and move around events and such to coordinate the use of our meeting/event spaces, but a lot of them aren't really "computer people" so they end up dragging the sheet into a mess of mismatched borders and colors. I just want to be able to set the framework for the layout of the sheet, and have it so that if anybody moves something, it's just the content that moves and the cell-structure stays the same. Thanks for any input on this. ~Joe |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Creating a Macro to change the shading of a cell
|
Triscia | Word VBA | 3 | 01-30-2013 04:18 PM |
Moving sum
|
dmrj78 | Excel | 3 | 10-29-2012 12:34 PM |
Page-crossing borders in a table with hidden between-cell borders
|
tenpaiman | Word | 2 | 08-08-2012 07:20 PM |
Macro for moving one cell down from current position
|
Johnny thunder | Word VBA | 3 | 04-07-2011 04:44 PM |
Moving formula range multiple cells when moving sum over one cell
|
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |