View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hibbs Phil Hibbs is offline
external usenet poster
 
Posts: 100
Default Conditional enabling of menu items

I've made an add-on that creates a menu item, but I only want it to be
enabled if there is a spreadsheet open. No, it's worse than that, I
only want it enabled if there is a cell selected. Basically I want to
mimic the behaviour of the Format-Cells menu option. How do I detect
this status and dynamically enable and disable my menu item as these
things change?

Phil Hibbs.