ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open my XL File with spacific computer ! (https://www.excelbanter.com/excel-programming/421239-open-my-xl-file-spacific-computer.html)

Tufail

Open my XL File with spacific computer !
 
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.

Barb Reinhardt

Open my XL File with spacific computer !
 
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.


Tufail

Open my XL File with spacific computer !
 
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.



All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com