+ Reply to Thread
Results 1 to 2 of 2

specify option to choose on alert msg?

  1. #1
    Registered User
    Join Date
    04-07-2005
    Posts
    14

    specify option to choose on alert msg?

    I have a macro that does several file saves and sheet deletes. How can I force the selection of the 1st option on all alerts when I am using DisplayAlerts = False ? An example would be a file SaveAs when you get an Overwrite YES-NO alert. I want to specify YES instead of the default NO without operator intervention. Thanks.

  2. #2
    Registered User
    Join Date
    04-07-2005
    Posts
    14
    I didn't test far enough. With DisplayAlerts = False, it appears that any alerts automatically have the option set to the first button. Sorry if I wasted your time. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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