Separating the .XLS yolk and the .XLM egg-white

[markf]

Progressing from http://www.vbforums.com/showthread.p...hreadid=280940

We are changing how we distribute this bulging Excel 97 project, by separating out as much of the Excel VBA Macro stuff (into .XLM), which all individual sheets use, from the Spreadsheet data (into .XLS), to simplifiy our back-end development and stab at solving the Project corrupting.

The current Spreadsheet is corrupted behind the scenes of its end-user(s), though the ordinary Spreadsheet, its Toolbar, and much of its VBA continue to work. Undesirably, the VBA Project has re-locked itself. We have temporarily disabled Spreadsheet sharing.

What are our options for extracting Spreadsheet data and importing it into a new Excel 97 Spreadsheet with little loss of cell detail (cell content colors appear to be its greatest detail)?

What are our options for integrating its Toolbar (ideally visible only when this Spreadsheet is loaded and Macros are enabled)?

I have not worked with XLM/XLS distributions before, and are still on my learning curve with Toolbars. Are there any recommended resources on the Net?

Thanks in advance,

Mark.

(Edited to remove * from *.XLM as just one Spreadsheet)

[markf]

My mistake, I meant .XLA Add-ins not the old .XLM Macro files. Whether .XLA or .XLM, I am still a novice.