I don't think you can stop any one if they really want to get the file. Excel's
protection just isn't made for that.

Maybe you could save the database file as a hidden file and have the main.xls
file open (and close it) when the main.xls file opens (and closes).

And if you give the database file a password to open (file|saveAs|Tools), then
maybe it'll stop most from trying to copy the database file.

(And if you save the database file as a hidden workbook, it might even be
better.)

But be prepared to answer questions like why is the file locked by someone
else--I checked their pc and I didn't see it open!





shirley_kee wrote:

I'm using Excel as my database. User access to the Excel database by
using another Excel I've created using macro. Basically it means, I
have one database called (CFS_database.xls) and another main screen to
access to the CFS_database (called "Main.xls").

When user edit the database through Main.xls, it will open the
CFS_database and do all the editing by using the form I've created.
These 2 excel files are share among users.

Even though they have full access to the file, how can I *prevent them
from copying CFS_database* to their own pc by using macro VBA?

PLEASE HELP... :)

--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: http://www.excelforum.com/member.php...o&userid=30384
View this thread: http://www.excelforum.com/showthread...hreadid=503893

--

Dave Peterson