Cable Forum - View Single Post

Raistlin · 23-05-2005, 14:59

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.

23-05-2005, 14:59	#3
Raistlin Inactive Join Date: Feb 2004 Location: There's no place like 127.0.0.1 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.