Have a cmd button on a sheet that transfers data elsewhere. The way all my code is written if the button is clicked again a second lot of data will be added.
I just know that someone is going to click this button more than once and cause a stuff up.
How can I disable the button so that once it has been clicked it will not be active again until the workbook is reopened. (Yes I will have to add a msgbox that lets whoever uses this know what is happening otherwise they will be clicking the button to infinity and wondering why things are not updating, even though they have done it once and probably didn't notice).
Any elegant solutions?
Thanks
Bookmarks