Command Buttons

gjadcock

New Member
Joined
Sep 17, 2002
Messages
27
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
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Each of the Worksheets in the Workbook are effectively seperate modules so you need to specify the worksheet that the button is on. Something like:

Worksheets("Sheet1").ButtonName.Enabled=True

Should do the trick.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top