Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make tools button grey
I can vaguely remember using personal workbook when coding for Mac but that
was long time ago and I only use Windows now. Try if this works: if workbooks.count = 0 then 'i'm not sure what buttons, so... end if "Huyeote" wrote in message ... Thanks for the reply. But my subs called from those buttons are in Personal workbook. How can I make a sub in Personal workbook and count number of workbooks open. If count is zero, set Enabled proper to false. Regards, Huyeote "kiat" wrote in message ... Set its Enabled property to False: yourbutton.enabled = false "Huyeote" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable the Options button from the Tools Menu | Excel Worksheet Functions | |||
Can't make changes in Tools/Options in Excel 2003(2) | Setting up and Configuration of Excel | |||
how do I make "Add-in" in Excel tools menu active? Its grey now | Excel Discussion (Misc queries) | |||
In Tools |
Excel Discussion (Misc queries) | |||
Make tools button grey | Excel Programming |