View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
losmac losmac is offline
external usenet poster
 
Posts: 27
Default 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