LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enable the Options button from the Tools Menu Dacasinoking Excel Worksheet Functions 2 April 14th 07 11:10 PM
how can i make macros to work when in tools, costumize and option. MOLECULA0_0 Excel Worksheet Functions 2 May 18th 06 04:54 AM
Can't make changes in Tools/Options in Excel 2003(2) CDNewell Setting up and Configuration of Excel 0 February 18th 06 01:49 AM
how do I make "Add-in" in Excel tools menu active? Its grey now Ant Excel Discussion (Misc queries) 1 January 17th 06 01:00 PM
In Tools Jibble Excel Discussion (Misc queries) 3 August 5th 05 12:59 PM


All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Š2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"