Quote Originally Posted by FDibbins View Post
I know this is not the answer you want to hear, but it is always better to train useres better, than to try and make allowances for where they will mess up. Believe me, they know FAR more ways to mess up, than you (or any1) does about correcting them....work in the old addage that prevention is better than cure

Maybe add a HUGE sign at the top saying DONT cut/paste, use COPY/paste instead

Considering all the formulas in the reporting tab are different, and each reffer to different cells (there are like 180 and formulas in one column, each with 150 arguements, and and nothing is repeated at all between each formula lol) that is probably what I will just do...

Is there a way to make a popup when they select that tab that reminds them to not cut? If it popped up and they had to push ok every time they opened the tab i would hope they remember.

mehmetcik's solution seems legit, but an incredible amount of work considering how my formulas are setup, and for how little i know about VB.