View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M. Authement M. Authement is offline
external usenet poster
 
Posts: 94
Default Enable/Disable CommandBar Buttons Based on Events

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.