Hi, I'm a bit of a numpty when it comes to VBA, but have managed to write some codes that performs actions when a command button is clicked, part of which is to set the enabled flag to False to disable the button.
Now, I want to set enabled back to True when the sheet is closed. So have put "ButtonName.Enabled=True" in the WorkBook_BeforeClose event but this gives me an error - Object Required.
What do I need to do to get this working??
Thanks in advance
Now, I want to set enabled back to True when the sheet is closed. So have put "ButtonName.Enabled=True" in the WorkBook_BeforeClose event but this gives me an error - Object Required.
What do I need to do to get this working??
Thanks in advance