displayalerts

I have an excel application that runs 24/24. During the day, there is a cycle that is run every 10 minutes. After that cycle, it is saved with the save command. For several weeks now, when saving, we have been getting a message on the screen every now and then saying that the file does not exist...

I have a VBA code with multiple subs and it has multiple worksheets which will be hided and only macro worksheet will be visible. when someone runs the macro it will unhide the other worksheets and exports the output then at the end it hides the worksheets. problem is at times towards the end...

Hey All, Happy Friday- After a bit of googling I haven't found a way to force DisplayAlerts to stay False. According to the quote below, Excel's behavior automatically resets it to true whenever code stops executing. "If you set this property to False, Excel sets this property to True when the...

Hi I removed application from the second line like this DisplayAlerts = False but that did not work, excel gave me the warning. Why I need to add Application. in this case? because with workbooks, I do not need to add Application. So I can say workbooks.add instead of...

Hi I hope you can help me out with this problem: I'm running af script with the purpose of creating a Histogram. I'm using this code that (actually!) works: Application.Run "ATPVBAEN.XLAM!Histogram", ActiveSheet.Range("$A$2:$A$5000") _ , ActiveSheet.Range("$E$1:$F$12")...

Hello and thank you for taking my inquiry. I am learning about VBA code and am wondering why when stepping through these lines of code I am not presented with a warning prompt. It executes successfully but no warning. The sheet is deleted. Sub DeleteSpecificSheets()...

Hi All. I have a workbook that extensively uses [worksheet scoped] named ranges (hundreds). When users copy data from one worksheet to another, Excel prompts the user to use existing instances of the range name or define new ones. While DisplayAlerts = False would suppress these messages, I...

Hi everyone, I searched the forum and internet but couldn't find the exact solution for this. I am running a macro which checks a value (the values I am checking have sheets named after them) If the sumif of the value is zero I am deleting the sheet. Anyways I used...

Hi I'm running a macro that gets a file from the internet. My code is like this: (i got it recording the macro) With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;https:// here my url..." _ , Destination:=Sheets("mysheet").Range("$A$1")) .Name = "the name here"...