Protect Borders When You Copy & Paste

[Laurinda]

Hi,
I have an Excel 2010 spreadsheet with borders around selected cells, the spreadsheet is protected so my formulas can't get corrupted, but with some cells that are unlocked for user data entry. But when you copy and paste in these user entry cells the borders are getting copied and pasted also destroying the look of the spreadsheet. so how do you protect the borders from being changed and still allow copy and paste in the user entry cells?

I do know that you can copy & paste values, but this is being used by dozens of people (some advanced users & some very basic users), so it's very difficult to ask them all to do this.

Also, I do know that you can insert columns & format the borders on the cells outside the area, but I am copying & pasting this into another spreadsheet & with merged cells, etc it will make it extremely difficult.

Any ideas at all? Thanks in advance!

 

[Steve=True]

Hi Laurinda,

Not sure this can be done to just protect borders unless there is a VBA way.

However, you could create a new worksheet with the formatting the way you want it and those cells are just formulas that looks at the cells that people copy/paste into.

This would retain your formatting while letting them go for it.

I do this in an upload file where users paste data, then i have another sheet that strips out all Tabs, Hard Returns, Commas, Non-Printable Characters with simple formulas.

Then when you copy from your new sheet, you would choose if it is just values or values and formatting.

Maybe that would be the easiest.


Steve=True
www.exceldashboardtemplates.com