Inhibit Sub when running another Sub

Hi,

I have an excel spreadsheet, where I am running Sub A, which checks, if users change entries. If so, in column R, the name and in column S, the date is saved.
Now, I programmed Sub B, that cuts and pastes designated rows into an archive file. I would like to inhibit Sub A, because each row that is cut, means that the subsequent row switches lines, and columns R and S are updated (while no actual change occurred). Does someone have a suggestion for me?

thanks in advance!

So are you saying Sub A is in fact an Event driven sub routine - ie Worksheet_Change event or some such ? If so you can disable events:

Please Login or Register  to view this content.

Note use of Error handler - when disabling events it's important to ensure that should the code fail for whatever reason that it is handled such that events are re-established.