View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_77_] Bob[_77_] is offline
external usenet poster
 
Posts: 61
Default Workbook closing

Hi all:

In excel 2003, I am setting some CustomProperties for the active worksheet.
However, before the workbook is closed, I would like to delete all the
custom properties. Does anyone know how I can find out when the workbook is
closing, and in which event I have to write my code for. Please note,
ultimately, my code would become an Add-in, and would not be tied to any
workbook in particular. Thanks for your help.

Bob