Hello,

I made a small macro that runs off a command button, which the user needs to press only once when they've completed using the sheet.

The macro edits some columns and removes things that aren't required.

But if the user accidentally clicks the button more than once it repeats the process, removing information that needs to be kept. Is there something that can be added to the macros code that would only allow it to be pressed once?

Cheers,

Weasel.