View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default How to make VBA code to self-destroy itself?

Hi Paul
I wouldn't recommend this.
First: Easy to circumvent by an experienced user by disabling this code part
Second: Not sure if you're allowed to do 'deleting' code and the possible
legal consequences.

Bottom line: In Excel there's no real way to protect/secure your code

"count" wrote:

Hi,
I need to ensure that users keep updating software in VBA. So I need to warn
them, say 1 month in advance and past that, I need to disable their access
to crucial module.
I thought of removing that module. How do I do that programmatically?
TIA
Paul