View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shirley_kee
 
Posts: n/a
Default How to prevent user to copy excel file to their own pc


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