VB and shared workbooks don't get along too well. You can try it but it
usually proves to be very problematic.
--
HTH...

Jim Thomlinson


"Liam" wrote:

I intend to use a shared workbook to hold what is essentially a database of
stock requests.

I would then use various other workbooks to manipulate the data in this
shared file (Also to act as a GUI).
Before these workbooks make changes I want them to update the shared book so
they dont overwrite any new rows th other workbooks have added.

Is there a command in Visual Basic which will allow me to do this?

I am aware the are more appropriate programmes for this application, but
until I learn how to use them this will have to do.

Many Thanks,
Liam :o)