You should put your code in an addin.

So yes, separating your code from the data is the solution.

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97


http://support.microsoft.com/?id=211563
How to create an add-in file in Excel 2000


http://msdn.microsoft.com/library/en...xceladdins.asp


http://msdn.microsoft.com/library/en...vrcreatingexce...


http://www.j-walk.com/ss/excel/tips/tip45.htm
Excel 97: Creating Add-Ins


http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

--
Regards,
Tom Ogilvy


"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:564483a1dc6c4@uwe...
Hi,

i have the following problem:

I built an application that uses two sheets for database purposes.
The application is distributed through to many collegues.

When i update the application, all data in the databases will be lost
because
i just save the new application over the old one. I would like to be able
to
update the application and leave the database intact.

my questions
- Is it possible to do that by making two workbooks like 1 workbook for
the
application and one for the database ?
- is it possible to save to a database workbook that is not opened ?
- is it possible to retrieve data form a database workbook that is not
opened
?

- is there some way of making it one file consisting of two workbooks?

Ik hope somebody has the answers for me.
Thanks,
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1