ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Allow a file to open on no more than 3 computers (https://www.excelbanter.com/excel-programming/380680-allow-file-open-no-more-than-3-computers.html)

[email protected]

Allow a file to open on no more than 3 computers
 
Is there a macro or function that will limit the number of computers
that a file can open and operate on, regardless of how many times the
file has been renamed? I prefer to limit the number of computers to 3
if possible. Thanks.

Michael


Tom Ogilvy

Allow a file to open on no more than 3 computers
 
Unless you were using some type of central registry, there would be no easy
way for a macro to determine how many computers a file was installed on,
particularly if it is renamed. Even if there was, any macro based solution
could be easily defeated.

--
Regards,
Tom Ogilvy

wrote in message
ps.com...
Is there a macro or function that will limit the number of computers
that a file can open and operate on, regardless of how many times the
file has been renamed? I prefer to limit the number of computers to 3
if possible. Thanks.

Michael




[email protected]

Allow a file to open on no more than 3 computers
 

Oh well. Thanks anyway.

Michael


NickHK

Allow a file to open on no more than 3 computers
 
Michael,
Sounds like a task for the OS permissions rather than Excel.

NickHK

wrote in message
ps.com...
Is there a macro or function that will limit the number of computers
that a file can open and operate on, regardless of how many times the
file has been renamed? I prefer to limit the number of computers to 3
if possible. Thanks.

Michael





All times are GMT +1. The time now is 12:41 PM.

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