The enhanced userpage module is a Wikiscript that enables users to attach a full external CSS document to their userpage. However, other users can only see the enhanced version of your page if they also have the module installed. Installation itself is no different than the installation process for any other Wikiscript. Simply having it installed does not alter your own userpage and will only enable you to view the enhanced version of others' userpages.