1. A

    Macro to end pop up file opening

    Guys can anyone have macro to end the selected file from pop up. 1.File should not pop up after executing
  2. K

    Pop up box - Route control

    Hi Guys, I am looking to get a macro created for an excel sheet, I have tried searching on here and cannot come across anything. I have a sheet that contains a list of all the departure times and assigned route number and amongst other details. Departure times is in A3 onwards to 400+ And...
  3. emiguy

    VBA to prevent pop up of File XYZ exists

    Hi everyone. I asked part one of this question and it was answered quickly. HOW CAN I FIND THAT THREAD SO I DON'T DUPLICATE IN THE FUTURE?? (uggh....sorry) Goal: I have a 365 macro to save the file as a XLS file, then a PDF. Someone (thank you to that person!!) answered the question, but now...
  4. Jaafar Tribak

    Your Typical VBA Standard MsgBox Behaving Like A TimeOut PopUp With Added Formatting And Some Cool Animation !

    Hi, I have been playing around with this in order to make this kind of plug-and-play timed popup, entirely based on the standard vba MsgBox after having manipulated it with some API calls... A good alternative for the buggy Shell popup. The popup has some cool features such as an optional...
  5. D

    VBA if specific pop up then close

    Hi everyone, i am working on a macro which populates an input table for BEX analyzer add in. I am using sendkeys method and there is a popup that comes up if the input is wrong. is there a way for me to make an if statement depending on the title of the alert. for example: If popup title =...
  6. N

    Excel VBA Date Picker for win64 bit

    Hello, I'm using Microsoft Office 16 in windows 10 / 64bit I'm looking for a solution to have a popup date picker in my userform I'v been searching for a solution long time ago, found a lot of solutions but most of them for 32bit, and some for 64bit but none of them worked correctly Please I...
  7. D

    If date does not match in column then return popup issue

    Hello. This forum is absolutely wonderful and I have learned so much- so Thank You All. I have one last code to finish a spreadsheet I have been working on. I am attempting to write a code that checks column B (which contains dates) and if all dates in that column do not match then it should...
  8. T

    Create popup menu to unhide worksheet

    Hi! I am looking for a code that will create a popup menu that appears when a user opens the workbook. The menu would have 4 choices and each choice would unhide a different set of tabs. Below are the menu names and tab combinations. I'm not even sure where to start. TIA!!! Menu Option...
  9. M

    VBA Disabling 'Saving As' Popup

    How do I disable the popup that says Excel is "SAVING AS" with the bar that shows % complete? Application.DisplayAlerts = False doesn't seem to help. Application.DisplayAlerts = False ThisWorkbook.Save txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")...
  10. T

    Macro to tell people if a number is not negative

    Hi Everyone, I need a macro that will run when data is input into cells D6:D16 that will check if a number is negative, i.e -21 If it is not i need a message box to popup saying "Numbers Should be Negative!" but not stop a posative number being added. please help if you can. Thanks Tony
  11. W

    Popup box asking for password to unprotect cell

    Hi, I have a excel sheet that is used to calculate staff hours and the sheet is protected with a password to stop people changing it. It has checkboxes and fields which add up/minus etc depending on what is chosen, something that has taken awhile to produce and something I am proud of. I've got...
  12. U

    Popup when file name is "X" but when it is changed dont create popup

    Currently I am using the following in a spreadsheet we use for internal reviews. Private Sub Workbook_Open() MsgBox "Click OK, then please save with your file name before entering information onto the form", vbOKOnly + vbExclamation, "ATTENTION!!!" End Sub Is there some language I can use to...
  13. P

    Copy sheet with popup message asking to name the new copied sheet

    Hi, I have a master sheet I want to be able to copy by pressing a button then getting a popup asking what name I the user wants to name the sheet and then use that to name the sheet. Thanks.
  14. A

    avoid login to microsoft site popup

    I am processing thousands of xls files and randomly I will get a popup that halts my processing. It is a login window (https://login.microsoftonline.com). Why does that come up and how do I avoid this so it does not halt my execution of my code? thanks
  15. 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?
  16. C

    Chart Popup

    When user holds cursor over chart and editing pop up appears to teh right of chart. How do I turn that off? As always, your help is greatly appreciated.
  17. Nelson78

    Automatic file opening: a mystery

    Hello everybody. In the last few days something strange is happening on my pc: when I arrive at work, I detect the presence of an alert popup telling something like it is impossible to find the file xxxyyy under the directory zzz, as something is trying to open it (tomorrow I will provide a...
  18. T

    VBA to filter between two amount I put in a popup box?

    Hi Everyone, I want to create a macro that asks the peson to insert tow amounts into a messagebox or any kind of popup box then filters by this? I know how to use userforms so that would do me fine. I currently use this Sub Filterby1() Sheets("Master").Unprotect 'Password:="august"...
  19. Nelson78

    VBA, Outlook and Excel: how to inhibite Outlook popup that blocks automatic operations?

    Hello everybody. I have built a hybrid process that engages both Microsoft Excel 2007 and Microsoft Outlook 2007. The process is triggered by an incoming e-mail sent by a specific sender at any hour at minute 15. With VBA instructions set in Outlook, the mail .xls attachment is used to update...
  20. Ironman

    Click on popup calendar to go to past entry dates in column?

    Hello I have downloaded the Addin Popup Calendar. Right now I can only click a cell and the popup calendar will fill that cell with whichever date I highlight in the calendar. What I would like is to click on any date in the calendar, which then looks up and locates the relevant info entry...

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