Disable control form textbox button assigned to Macro on excel worksheet

Hi James,


Truth is setting the enabled property to false on a form control type button will not stop it from executing its code... but you are looking for

Please Login or Register  to view this content.

This will, as I said, not stop it from executing code, you could however change the macro that runs from the button to include a check and only run the code if the button is enabled:

Please Login or Register  to view this content.

Good point RdwJ! I assumed the OP did not want it to disappear, but I should have thought to suggest it... nice call.

Can you provide the workbook? Clean out any sensitive data of course, but I can't replicate the problem, if the sheet reference is the issue the error should be different, same with button name. Tried with a protected and hidden sheet, and still couldn't duplicate the problem.

One thing you could try is changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

a button should not have a True or False value, rather its Enabled property can be true or false.
I don't think that's your issue though, because the error should be a different one " Run-time error 438.
One thing to make sure is that there is a Sheet1. This is not the NAME but the code name (the part not in brackets in the VBA editor). If you want to refer to it by name it is Worksheets("Sheet1").Buttons...