alert

  1. F

    This formula uses more levels of nesting than you can use in the current file format.

    Hi, Im trying to run this query and getting the above alert. Any help is appreciated :-) =SUMPRODUCT(MID(0&E66, LARGE(INDEX(ISNUMBER(--MID(E66, ROW(INDIRECT("1:"&LEN(E66))), 1)) * ROW(INDIRECT("1:"&LEN(E66))), 0), ROW(INDIRECT("1:"&LEN(E66))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(E66)))/10)...
  2. B

    Disable read-only warning in yellow alert

    Is it a new thing all of a sudden that Excel is warning me that my file is read-only in the yellow security message towards the top of the sheet? Can I disable that somehow? To be clear, I want to keep the document as read-only, but I don't want to get warned about it every time I open it.
  3. Vincent Thank You

    If statement between months on hand and a date

    =IF(G74<((I74)-(MONTH(TODAY()))), "ALERT", "") <colgroup><col><col><col></colgroup><tbody> MONTHS ON O/H ALERT EXPECTED DATE 0.3 ALERT 8/30/2019 </tbody> Hello! I can't get this formula to work correctly! I'd like to have the word "Alert" added to the center cell if the difference...
  4. C

    Days between dates and color coding

    So I have specifation register listing 300 products, the date the specifcation was issued and the date the specification expires. Specifications expire after 3 years. I want to keep my specifcation file current by checking the difference between todays date and the expiration date. If the...
  5. A

    Macro to answer Alert question

    Hi all - I have a macro that will open a bunch of files, update the links, and save them. Occasionally a link can't be updated and an alert pops up. Is there a way in the macro to answer that pop-up? I want to code "Continue" to the Alert. Any help would be most appreciated. Amy
  6. H

    Alert - First Monday of the Month

    I'd like to have the word Project appear in cell E2 on the first Monday of each month. Any ideas on how to do that?
  7. kelly mort

    How to fix dynamic chart data error

    Hi I have these formulas I am using to plot my charts to keep track as the data expand and shrink . =Offset(DataSheet!$B$2,,,CountIf(DataSheet!$B$2:$B$12,"<>")) =Offset(DataSheet!$C$2,,,CountIf(DataSheet!$C$2:$C$12,"<>")) It's working great just that when the cell B2 or C2 becomes blank...
  8. N

    how to create an excel popup on timer?

    lets say i have a task. i put the start time in excel. i want excel to popup alert me when time is up. how do i do that?
  9. F

    A log of when an Excel document has been opened

    Hi, I have a document of someone else's that I check daily and it was made aware to me that the individual whose document it is, knew that I was doing this. And I wasn't sure how this was possible. As far as I know, there's no way to log when an Excel or Microsoft document has been opened...
  10. kelly mort

    Count images larger than a give size in a folder with vba

    Hello again, I have been searching the net for a while now to find a solution to my problem. I have come close in most cases but not right to the point. I want to go to a folder called "MyImages" in the location on my workbook. That's. ..... ThisWorkbook.Path & "\MyImages". Then I count...
  11. S

    Alert from excel file

    Hi all I have excel file with macro. Now my file popup alert when open and not allow to save file without save new one. Pop up alert like the image I attack, please tell me wha't the matter with my file. Thanks./.
  12. P

    VBA - Pop alert for list of dates

    Hello all, First of all, I tried to find a similar thread but without much success (as I'm new) for my question. So sorry, if there is already a similar thread and if yes and you have it, just point me to the right direction. Thank you. So I have a list of client contracts and I would like...
  13. M

    Alert when entering data in the workbook

    Hi all, I have a problem, i want a message to flash up when i enter specific data anywhere in a workbook (regardless of the sheet) IE. If i enter ME1 1XY in a cell i may want this to say: "Delivery probems, check list". The purpose is to alert delivery drivers if we have had problems...
  14. P

    Formula to spot upward trend

    Hi, I am looking to create some sort of formula that can throw an alert for the user if the upward trend is increasing. I need help with the algorithm For example, Months Jan, Feb, Mar, Apr, May, Jun Values 1024, 1130, 1250, 1375, 1425, 1250 Displaying this in a chart you could say the cost...
  15. D

    Disable or VBA to prevent 'Want to save your changes' alert, just want to save it without alert

    Hey guys:) I have a script that runs and closes on it's own, the problem is that sometimes i get this alert 'Want to save your changes to '***File***'? Because of this when the script closes on it's own it does not close properly. Is there any way to disable this alert message so that it just...
  16. M

    Make a range of cells mandatory if one cell is filled in as NO

    currently I have the code where I am making one cell mandatory when one cell is filled in as yes or no. I want an easier way to specify more than one cell to be mandatory when a certain cell is filled in as no code at the moment to make one cell mandatory 'Mandatory Dependant Questions If...
  17. M

    is there an easier way to make loads of cells mandatory then coding out for them separately?

    Hi, I want to make a lot of cells mandTORY, iS THERE AN EASIER WAY TO DO THIS RATHER THAN THIS CODE: After this can put no more code in as it says too many line continuations If Application.Sheets("WERS ALERT SHEET V14").Range("C5").Value = "" Or _ Application.Sheets("WERS ALERT SHEET...
  18. M

    how to remove update links dialog box

    I hope it is okay to post a new thread since this post was answered already. https://www.mrexcel.com/forum/excel-questions/299193-edit-links-startup-prompt-dont-display-alert-update-links.html?highlight=update%2Blinks Edit Links - Startup Prompt - Don't display the alert and update links. My...
  19. S

    Return 1 if criteria met or 0 if not - based on two criteria with both columns having multiple instances (duplicates).

    Hi, In column B I have ticket numbers and there are 12 instances of each ticket (may grow). In column D I have clients. In column E I have specific text (e.g., alert, no alert, etc). In column AM I need it to show 1 or 0. I want it to only count the first instance of colum B (ticket number) and...
  20. Nelson78

    Navigatine IE with VBA: a security alert, how to answer yes

    Hello everybody. I'm navigating IE with vba. Now, I need to answer "yes" to the following alert, as I do in manual navigation, to enter the intranet: https://imgur.com/a/J9SSbyI Consider: 1) the alert is exactly what you see in the image, but Current site and Intranet site are different (I...

Some videos you may like

This Week's Hot Topics

Top