I'm creating an Excel AddIn. The AddIn creates an Excel menu option. When
a client worksheet clicks the menu, AddIn code is executed that reads data
files, loads the data into an AddIn worksheet, and then creates global
objects (class modules instances declared Public in a standard module)
containing the same data. The AddIn worksheet is then copied to a client
worksheet.

The user has the ability to edit the worksheet and I'd like to be able to
save the data back to the global objects. But the client worksheet cannot
see or create instances of the AddIn class modules. What's the most
efficient way of passing data back and forth between my global objects and
the client worksheet?

Thanks,

Mark D.