+ Reply to Thread
Results 1 to 10 of 10

A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

  1. #1
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    183

    A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    I have a macro that copies and pastes information from spreadsheet to the other.
    I also have the following function
    Application.DisplayAlerts = False

    It seems to input this functions in to a cell on the spreadsheet itself
    is this a known bug?

    I am attaching the spreadsheet with the bug as well as the code
    How can this be solved?


    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,206

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    Your attachment downloads as a Word document "Clear All Budgets" which contains code in text format.
    Could you attach an Excel workbook?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    not for me it doesn't! i get find_photo.xlsm
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    183

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    Is there any solution to this issue?

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

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    What is the code meant to do and what is the problem with it?
    If posting code please use code tags, see here.

  6. #6
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    183

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    Try to run the macro in the spreadsheet attached.
    Sub InsetImage()

    You will be able to see that the macro inputs into the new spreadsheet the following Application.DisplayAlerts

  7. #7
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    well apart from the fact its extemely slow, it is NOT adding Application.DisplayAlerts = False
    from the code
    it is adding the last thing you copied to the clipboard tho
    copy something else any thing then run it
    eg this text "oh what is this doing here,hmmmm"
    Attached Images Attached Images

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

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    Why do you have this?
    Please Login or Register  to view this content.
    That will copy whatever is on the clipboard to the new sheet in the new workbook.

    In my case it copied Option Explicit to A5, where A5 was the last cell selected in the sheet that was copied.

  9. #9
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    183

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    What can I do in order to solve the issue?
    I tried to empty the clipboard info however this is not working.

    What is your recommendation in order to speed up the code?

    Thank you for your help

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

    Re: A bug which Inputs Application.DisplayAlerts = False As part of the spreadsheet

    To resolve the issue delete this line as it doesn't really do anything, well not anything you want as far as I can see.
    Please Login or Register  to view this content.
    As for speeding things up, I'm not sure you can make any changes to the code to do that as the reason the code is so slow is it's downloading the images from the internet.

+ 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. [SOLVED] Application.DisplayAlerts = False Doesn't work
    By Hiawatha in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2014, 11:15 AM
  2. [SOLVED] Application.DisplayAlerts = False does not work
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2013, 10:23 AM
  3. [SOLVED] Disable Run-Time Errors "Application.DisplayAlerts = False" Not Working
    By Punx in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-12-2012, 03:03 PM
  4. Application.DisplayAlerts = False showing True
    By SOS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2008, 06:36 AM
  5. Application.DisplayAlerts = False
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-18-2006, 12:35 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