Hi All,

I have created a small application using VBA on Excel 2002. Every month
I upload data into the data workbook, on a new column, from input files
using the macros which are stored in a different workbook.

I am facing some problems recently. I have no idea how but some data is
either getting deleted or changed. Is there any way I can protect my
data/macro workbook or may be lock cells.

What I was thinking is may be after every monthly upload I lock the
column that had been populated. But my worry is that if I have to, may
be in future, update some data then what should I do. Right now I am
taking copies of my workbook(s) every month but sooner or later I will
have space problems. This application will be run for the next 5 years
or so.

So can someone suggest me the best possible way for protection.

I have recently started working on Excel VBA (my background being AS400
before). Therefore I would also request someone to direct/suggest me to
any tutorials or books on the net as I want to fully understand what I
can do using VBA on Excel.

I think I have asked a lot here but would sincerely appreciate if
someone comes back to me asap on this.

Thanks & Regards,
Prasad