hi all,
is there any code that doesn't allow to open my excel file in other
computers except my computer, i means if someone move that file into other
computer and try to open (ofcourse my file has protected with a password)

thanks in advance.

You could write something for the Workbook open event to check for the
computer, however, if someone chooses not to enable the macros, this won't
work. Can you protect it any other way? Also, what happens if something
happens to you and they need access to the file. You need a backup.

My 2 cents.

Barb Reinhardt

"Tufail" wrote:

hi all,
is there any code that doesn't allow to open my excel file in other
computers except my computer, i means if someone move that file into other
computer and try to open (ofcourse my file has protected with a password)

thanks in advance.

plz give me some code for event check.
no most of them don't know very well about macro.
yes i just protect my workbook as well sheets with a password.



"Barb Reinhardt" wrote:

You could write something for the Workbook open event to check for the
computer, however, if someone chooses not to enable the macros, this won't
work. Can you protect it any other way? Also, what happens if something
happens to you and they need access to the file. You need a backup.

My 2 cents.

Barb Reinhardt

"Tufail" wrote:

hi all,
is there any code that doesn't allow to open my excel file in other
computers except my computer, i means if someone move that file into other
computer and try to open (ofcourse my file has protected with a password)

thanks in advance.