View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alice Graham Alice Graham is offline
external usenet poster
 
Posts: 11
Default Is there any protection change event?

I am working with Excel 2007 and VSTO.

I have added several buttons to the ribbon which format cells. I want to
disable these buttons on protected worksheets, in the same way that the MS
"Wrap Text" button behaves.

I have a "getEnabled" callback which works fine but I don't know how to
invalidate my buttons when the protection is changed.

Any help would be appreciated.