Excel 2003 best way to protect borders from being changed

[DougP]

we have grade sheets that we spent a lot of time setting up borders and shading. during the year as grades are added and change made etc they end up with missing borders or skinny borders and other mishaps.
Is there a way to protect them and still allow users to put in the grades and comments? do I need to create ranges for editing and others be protected? the borders are around the cells so when someone copies and pastes, it takes the border from another cell and over-wrights the border already there.


TIA

DougP

 

[SkipVought]

Hi,

Record a macro for formatting your data. It could run in the Worksheet_Change event.

Post your recorded code in forum707 for help customizing.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DougP]

problem with that is it took a very long time to get these formated. and we started with something and tweaked it, so recording a macro would be way too difficult. I don't even know where to begin.
I need a way to protect what we have and not have to re-create it to record umpteen-dozen borders and shading?

DougP