+ Reply to Thread
Results 1 to 5 of 5

Thread: How to display a window at Excel Startup

  1. #1
    Registered User
    Join Date
    10-11-2009
    Location
    london, englans
    MS-Off Ver
    Excel 2003
    Posts
    31

    Exclamation How to display a window at Excel Startup

    Hi all,

    Would anyone be able to tell me how to display a promp at an excel workbook startup so that users agree to the terms and conditions?

  2. #2
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    797

    Re: How to display a window at Excel Startup

    hello deanJ

    A simple userform would do it.
    One textbox (where the aggreemnent terms go), And two buttons (accept & dont accept.
    IF they dont ok it will close the workbook.

    Here is the example.

    Hope it helps
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-11-2009
    Location
    london, englans
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: How to display a window at Excel Startup

    Thanks you, much appreciated :o)

  4. #4
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2003, 2007, 2010
    Posts
    758

    Re: How to display a window at Excel Startup

    deanJ,

    See alternative example that I have been using. Has one additional feature in which the user must make an entry in the checkbox in order to "enable" the continue button.

    HTH
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-11-2009
    Location
    london, englans
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: How to display a window at Excel Startup

    Thanks mate works a treat!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0