Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable a workbook?
What can be done to disable a workbook? I have a protected workbook
named MyBook.xls. If someone copies it to MyBook1.xls, I want the copy to be unusable. What kind of thing can be done? One thing I was thinking was it could ask for a password if the filename had changed or path changed. A password he would not have. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable a workbook?
Yes, you could implement your idea.
But if the data is sensitive Excel is not the tool for the job. Any experienced Excel developer can get around tricks and obfuscations. In that sense what you want to do can't be done. For what you described a user can open the Workbook with the shift key pressed and rip out the code you added that prompts for a password. Other tricks I can think of: 1. Setting font color to white 2. Validating the user against Active Directory (so if they aren't on the network you can take some sort of VBA action) 3. I'd have to check - but I think you could use CDO to send an email message without the user's knowledge. (This is my favorite because the email message that's sent can provide information about the user's identity and what he's trying to do.) 4. Putting key VBA Modules and data Sheets into AddIns 5. Only distribute Templates instead of Worksheets and modify the templates to fetch data from a database - prompt the user with credentials to log in to the database 6. Store key data Sheets in Visual Basic DLLs 7. As a general rule - keep business logic in database functions and procedures - that makes it so someone can steal the data - but they can't steal the business logic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hoe to disable a workbook? | Excel Programming | |||
Disable WorkBook AutoOpen | Excel Programming | |||
disable workbook | Excel Programming | |||
Disable commands for one workbook | Excel Programming | |||
Disable cut paste in a workbook | Excel Programming |