+ Reply to Thread
Results 1 to 2 of 2

If user doesn't open file...avoid from the Debug message coming up

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    If user doesn't open file...avoid from the Debug message coming up

    Please Login or Register  to view this content.
    Hi
    in the event the user closes out of the directy (in which they are supposed to select a file...) how Can I have excel just stop running the program in a friendly way. Like "oops You didn't select a file"

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: If user doesn't open file...avoid from the Debug message coming up

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Coming a debug "unable to get the OLEObjects property of the worksheet class
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-07-2014, 02:33 AM
  2. Auto Filter using combobx, coming up a debug
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2014, 02:08 AM
  3. [SOLVED] Code optimization to avoid multiple file open calls
    By smpita in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2014, 01:31 PM
  4. Macro coming up with debug error,
    By donnydorko in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2009, 11:56 PM
  5. How to avoid 're-open' alert while opening file
    By excelquestioner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-24-2007, 02:29 PM

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.6.0 RC 1