Forum Discussion
protect borders
Hello, is there a way to protect borders on excel? We have forms that have different thicknesses in the borders and when people copy and paste, the thickness can change, which makes the whole form l...
It's so annoying that you can't protect borders, as they are the mainstay of Excel. Pasting Values is such an inconvenience when I am using large spreadsheets, and I like to use coloured shaded cells a LOT. I have gotten used the my borders being incomplete everywhere - it's such an unprofessional look.
Set up a separate worksheet with the proper formatting for all cells.
(no values or formulas)
Hide the sheet.
Write VBA code to paste the hidden sheet formatting into the messed up sheet.
(just a few lines required)
Add a button to the QAT to run the VBA code or it could be done automatically before each Save.'---
Nothing Left to Lose
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
(free excel programs)
