I've found so many options to this and can I get any to work???? No.
Well there was one but as it used undo in the macro it meant it wouldn't work with other macros.

All I need to do it on select worksheets I need to protect the formatting. Specifically B4 through to D125 but if it works on the whole sheet thats fine.

What I mean by this is to when a user presses ctrl V or selects paste from the menu, it only places the tex/values, I don't want any borders or formulas pasted in.

This must be simple?