application.displayalerts

  1. D

    Lost functionality

    We recently lost functionality within one of our workspreadsheets. Our I.T. departments thinks that it may have something todo with a recent Microsoft update and a dated excel macro. When the macro is working properly it should open a separatereference spreadsheet, copy a range of cells...
  2. P

    Find the string in all excel files in destination folder and subfolders

    Hi all, I am trying to write a code to search a strings listed in the active sheet in all excel files in a folder having multi level of subfolders. I searched and found following code which is working for me but I need to search only sheet called "Test" in each excel file. This code searches in...
  3. 0

    Modify code to cycle through all the workbooks in the folder

    I have written the following code that extracts several pieces of data from all the worksheets in that file. How can I modify the code (which I can move to a separate workbook, that would cycle through all the workbooks in a specific directory, creating one table of data for all the workbooks...
  4. M

    When using for each loop for delete worksheets ( showing error msg for completing the task

    Sub ForEachLoop1() For Each cl In Range("A1").CurrentRegion cl.Select If cl = 10 Then cl.Interior.Color = vbRed End If Next cl End Sub Sub ForeachExample2() Application.DisplayAlerts = True For Each ws In ActiveWorkbook.Worksheets If ws.Name = "Delhi" Then Else...
  5. B

    Application.DisplayAlerts=False & ActiveWorkbook.Saved=True Not Disabling Save Prompt at Close

    I am using TaskScheduler to open a spreadsheet to run an Auto_Open subroutine. The Auto_Open subroutine calls various subroutines to pull data from a server, perform calculations, update charts, export pdfs, and send emails. At the end of Auto_Open, a timed popup allows user intervention to stop...
  6. J

    Display Alerts problem..

    Hello all, So I'm having a bit of trouble understanding Application.DisplayAlerts.... Why can it not stop this error from displaying... I have this in a workbook open event and every time it opens it shows this alert. I also run some code to update my links which is why the alert is even...
  7. C

    Application.displayalerts issue

    Hi all I am having a problem when using application.displayalerts and it has me scratching my head a bit. I am using this to supress the alert when deleting a worksheet: Application.DisplayAlerts = False Debug.Print Application.DisplayAlerts sh.Delete Application.DisplayAlerts = True When I...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top