Closed Thread
Results 1 to 4 of 4

Posted on another forum >> Disable "Select Sheet" Dialog box

  1. #1
    Registered User
    Join Date
    03-06-2007
    Posts
    9

    Posted on another forum >> Disable "Select Sheet" Dialog box

    Hi to all.
    Please, I have a problem. Im trying to update some formulas with VBA functions, changing links to other workbooks or other sheets. I've used Application.DisplayAlerts = False to disable the UPDATE LINKS dialog box (if the workbook is missing, it doesnt matter). But if the workbook exists and the sheet doesnt, I got the SELECT SHEET dialog. Application.DisplayAlerts doesnt work for that.
    Any sugestions?

    Thanks a lot for response. But, It doesnt work
    I dont know why Application.DisplayAlerts = False works on missing excel files or workbooks, but doesnt work on missing sheets.
    Application.AskToUpdateLinks = False doesnt work

    Hi.
    It's Windows Media Center Edition.

    This is exactly what I want:
    In a macros function I'm changing formulas
    ='\\..\Mark\Analisis\2006\Files\[TOTAL_2006.xls]AGT'!$E$6
    to
    ='\\..\Mark\Analisis\2007\Files\[TOTAL_2007.xls]AGT'!$E$6

    If the files is deleted, doesnt matter. I can get a invalid REF. Application.DisplayAlerts = False can handle that.
    But if the file exists, and the AGT sheet is not in that workbook the "Select Sheet" dialog is opened and the runing macro is stoped. I dont want that dialog box.

    I've got a routine that cycles through all Excel formulas and changes the ones that meet a particular criteria. Some of these links are broken (weren't working before, not going to work after) because the sheet of the file they're supposed to point to doesn't exist. Excel's clever and offers me a dialog to choose the sheet I want, which naturally interrupts my code. What I need to happen is to avoid this dialog altogether, leave the link as broken, move on to the next one.

    If the link file doesn't exist at all, Application.DisplayAlerts does suppress any messages. However, when the file exists but the sheet being referred to doesn't, that's when I get this problem.

    Trapping an error doesn't appear to work as no error actually occurs until I don't select a new sheet.

    Anyone got any ideas please?
    Last edited by VBA Noob; 03-06-2007 at 05:10 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Gtorres,

    You can turn it off this way...
    Application.AskToUpdateLinks = False

    Sincerely,
    Leith Ross

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Gtorres,

    What version of Windows are you running?

    Sincerely,
    Leith Ross

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Gtorres,

    Sorry, I am not familiar with Windows Media. Someone in the forum probably is though.

    Sincerely,
    Leith Ross

Closed 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