Ok I have a worksheet that alot of info is input daily. Each day it is saved
with a new name and there is a macro recorded to delete the previous days
info and then we put in the new info. In some blocks there are numbers that
are copied and put in another block, ie dates and meters. Somehow some of
the blocks arnt doing what they are supposed too so I'm trying to go through
and redo it. I know how to do the special paste to transfer the info over
but when I try to reset it, because the blocks are formated to be locked, it
will say something about debuging. How do I make it to where it will paste
the info and keep the blocked locked? It was done before with the old sheet
so I know it can be done, I just don't know how. Thank you for any help!