protect borders on a data entry cell

D

dotcom

I have an Excell 2007 spreadsheet with borders around selected
cells, the spreadsheet is protected so my formulas cant 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?

Thanks in advance
Terry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Need Help with a VBA subroutine 0
Linking data in MS Word into Excel 5
VB Script reference cells for in current table? 1
Creating a Chart on form from selected data in query. 0
how to control the gray line on the border? 5
Paste Value 1
Pasting a cell into bookmarked table from excel vba 1

Top