View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
strataguru[_5_] strataguru[_5_] is offline
external usenet poster
 
Posts: 1
Default XLapp and SheetChange

Hi,

I am just learning about the XLapp functionality - and have been trying
to use this in my addin.

The problem I have is that I have a sheet setup macro that creates a
number of sheets, formats them, and creates column headings. Everytime
a sheet is updated - the XLapp_SheetChange is called.

Problem is that I have one sheet that I want the XLapp_SheetChange to
recognize and 'do' things - but I don't want it to do things when the
setup macro is running.

Is there a way in the XLapp_SheetChange I can tell that the setup macro
is being executed?

Thanks!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/