ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Enabling a Embedded Control (https://www.excelbanter.com/excel-programming/276641-enabling-embedded-control.html)

Kirk[_2_]

Enabling a Embedded Control
 
Thanks for the response. I figured it out.

It is simply Worksheets("TabName").cmdButton.enabled =
false (or true)

I should have known it was something simple.

Kirk

-----Original Message-----
I added a command button control to a spreadsheet. I
have it intially disabled, but want to enable it after
the spreadsheet has been updated correctly. I want to
enable it through VBA code. How do I do this? I'm sure
it is simple and I am overlooking something.

As always, all help is appreciated.

Thanks.

Kirk
.



All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com