You are here: Home | Forum | For you Windows XP 64 Bitters out there...
You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.
The company my Dad works for have had some stuff done in Excel which includes macros and VB code that has been written by them. The macros are password protected so people can't steal them (supposedly) but now they want to give the program out to a few customers. They've asked me if it's possible to give a good level of protection to their program and also if the program can have a usage timeout (stops working after 30 days) that can be set by them before they give it to the customer. I don't know why they've done it in Excel as the security in there is always crackable and they don't have time to let me rewrite the whole thing in VB or something. They will be giving the program to customers on CD. Anyone have any ideas? I've looked at the standard workbook passwords and VB password stuff and also creating a dll but it doean't seem very good. As for the CD protection timeout that probably can be done but with 3rd party software.
Services: Depends on the person and the price they're offering
Posts: 12,384
Re: Excel and VBA, how to protect?
You could look at the Autoexec automation for Excel.
You can include a module called (I think) Autoexec in the VBA for the worksheet. This runs as soon as the worksheet opens. Then use the code above (or an approximation of it to suit your needs) to test the date. If the date is out of the allowed bounds you simply close the sheet.
Hopefully your clients won't necessarily be able to bypass this very easily.
Ah thanks for the suggestions so far, sorry I didn't reply sooner, had to go to work! Just had it emailed to me, 14 worksheets and 31 Macros so I don't think this is a quick job. I'll try autoexec first though!
Join CF
You are here: 
