Disable a button after macro runs

scubadiver007

Registered User.
Local time
Today, 05:11
Joined
Nov 30, 2010
Messages
317
Can I do it on the form or does it have to be a function or command in the macro?
 
I don't think you can hide a button using a macro unless its with the "Set Value" function?. But there are two ways I know of. The lazy way is if the last action on your macro for example fills in data into a text box on the form then use that text box "After update" event to hide the button.

Or the better way,

Convert your macro into VB and add the code at the end in this format

YourButtonName.Visible = False

Remember you will also have to reverse that action at some stage to enable the button again.

If you don't know anything about VB then now is a good time to start.
 

Users who are viewing this thread

Back
Top Bottom