Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Permanently scrap a dialog box with a check-box! (Excel 2000 >)

    If I have a welcome dialog open with the spreadsheet file (On Open Event), and I have an option on the welcome dialog to select a check box which says: "Check this box to not show this welcome message again", how do I do this. Would it be a static variable or a constant that is set??? Please point me in the correct direction!
    Regards,
    Rudi

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Permanently scrap a dialog box with a check-box! (Excel 2000 >)

    It would have to be something that persists accross Excel sessions.

    Many options come to mind:

    Registry entry
    Small text file
    Hidden name in the workbook
    Cell on hidden worksheet
    ......
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Permanently scrap a dialog box with a check-box! (Excel 2000 >)

    So take a pick and tell me which one you would pick if you had to do this? (Lend me your brain!) <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Permanently scrap a dialog box with a check-box! (Excel 2000 >)

    A custom document property would be a suitable candidate:
    - Select File | Properties
    - Activate the Custom tab.
    - Type a name, for example WelcomeScreen.
    - Select Yes/No as type.
    - Make sure it is set to Yes.
    - Click Add.

    In your Workbook_Open code, check the property:

    If ThisWorkbook.CustomDocumentProperties("WelcomeScre en") Then
    ...
    End If

    and in the code to turn off the welcome screen, use

    ThisWorkbook.CustomDocumentProperties("WelcomeScre en") = False

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Permanently scrap a dialog box with a check-box! (Excel 2000 >)

    Yes, I understand now...thanx. Its similar to Jans suggestion of a hidden name in the workbook! OK. This advice ought to do it for me.
    Cheers
    Regards,
    Rudi

Posting Permissions

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