View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Enable/Disable CommandBar Buttons Based on Events

Maybe i'm just confused but if no Workbook is open why would you need to
disable the commands?

"M. Authement" wrote:

I have added a menu item with several sub-menu commands as part of an add-in
I am developing. Many of these commands deal with modifying or inserting
cell formulas, so I would like to disable those commands if no workbook is
open or if the activesheet is not a worksheet. How do I go about doing
this? I am using WinXP, XL2003.