Consulting

Results 1 to 3 of 3

Thread: Information sheet or message in xlam?

  1. #1
    VBAX Tutor
    Joined
    Jan 2008
    Posts
    266
    Location

    Information sheet or message in xlam?

    I have a xlam file that can install itself on a computer, but it requires macros to be enabled.

    Can I add a sheet or background picture or message or anything that tells the user to enable macros?
    Now when you open the file you get a "empty" window, basicly just gray.

    What I want is something else than the gray telling the user everything is as it's supposed to be.

    Any suggestions?

  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    An .xlam is always hidden. And you can't run code to unhide it for obvious reasons. Default settings for Office allow macro code to run in installed add-ins, so I'm not sure why you are having an issue, really.
    Be as you wish to seem

  3. #3
    VBAX Tutor
    Joined
    Jan 2008
    Posts
    266
    Location
    Sorry, maybe I was unclear.

    If the file is not installed (xlam is placed on the desktop for example) and user opens the xlam he/she will get a message asking if they wish to install it.
    And if yes, then it will install itself in the addins folder and activate itself.
    All this is working

    I just want to replace the gray background with something else when you open the xlam.

    But if it's hidden as you say then I guess there isn't much that can be done.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •