Make tools button grey
 

CommandBars("yuor_commandbar").Controls("button_na me").Enabled = False


U¿ytkownik "Huyeote" napisa³ w wiadomo¶ci
...
Hi, all, I notice that colour of Excel's button in Excel's tools bar will
go
grey when there is no workbook open. Can anybody tell me how to make my
own
DIY macro button's colour go grey (invalide) just as those Excel's
build-in
buttons do. Thanks.

Huyeote