The best place is probably the registry. Have a look at SaveSetting and
GetSetting in the VBA help file. It is far faster than having to save your
entire add-in to preserve this information.

Robin Hammond
www.enhanceddatasystems.com

wrote in message
oups.com...
Hello,

I am creating some objects and data structures in my add-in code while
working with Excel. I need to save the state of these objects with the
workbook so that these objects can be brought back in memory when the
workbook is opened.

Currently I am saving the state as binary data in a hidden sheet in
cells.

Is there a place holder in the Excel Format to save such binary data?

Regds
Gap