Assigning a macro to a button

[psychotrends]

Hi,

I know you can assign a macro to a button to make easier but can you add some code to prevent the user from clicking it twice and making a mess?

Thanks
psychotrends

[Logit]

.
You can add this line at the bottom of your macro :

CommandButton1.Enabled = False

Note that CommandButton1 is the name of your button. So if you have called your button MyButtonForMyMacro ... then the command would be MyButtonForMyMacro.Enabled = False

At some point in your project you will need to re-enable the button for future use.

[psychotrends]

Thanks a lot.
It worked!

[Logit]

You are welcome.