View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nacho Nachev Nacho Nachev is offline
external usenet poster
 
Posts: 26
Default Generating content on the spreadsheet from an Add-on issue

Hi,

I am creating buttons on a spreadsheet through a C# code from an add-on
module.

The functionality is implemented and works. My problem is that this module
is run at a relatively radom time, so it sometimes bumps into situation when
the active sheet is not available for writing - for example when there is a
modal Excel dialog window open.

My question is: How can I detect such conditions in order to avoid running
my code in such moments? Probably I just need a hint to start from.

Another important information is that my add-on uses separate thread to
access the Excel object.

Thank you for your time,
Nacho