XLS Padlock provides you with some VBA routines to detect whether the EXE is run in trial version or not. Depending on that, you can let the user access VBA routines only available to registered users or not (and even display a message that this will be available only after purchase for instance).

The VBA routine to be used is in this section: Check if the compiled workbook is in trial state