View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Code for Trial Version

Common recommendation is to hide all your sheets except one that cautions
the user to enable macros. So if macros are enabled, then in the
Workbook_Open event, you would "set up" your workbook and in the
Workbook_BeforeClose Event, you would hide the sheets and save the workbook.

There is no standard code for this, but if you have developed an application
that uses VBA, then you should have no trouble designing your own.

You can search google groups for past posting on this topic and this group
and probably get some sample code.

http://groups.google.com/advanced_group_search?hl=en

--
Regards,
Tom Ogilvy

Sadik wrote in message
...
Where can I get codes for creating a trial version
workbook / self deleting or read about it to learn (I know
Excel VBA is not very secure and can be broken into.
However, vast majority would not know how). Thnks for your
help.