1. D

    Overriding Conditional Formatting Color with Manual Entries of a different color

    Hi Everyone! (Sorry this is so dense) I am trying to find a way to use conditional formatting to override my existing conditional formatting, while still retaining it underneath. I want to do this by having the conditional format recognize when I have input a date manually VS. our...
  2. M

    override a copied columns in summary sheet

    Dear Sir, if i am trying a column to be copied into destination sheet from multiple workbooks it is override a copied columns in summary sheet. means last workbooks column values is reflecting with only single column. please help for this issue. please find the below code. Sub CopyRange()...
  3. ACommandLineKindaGuy

    Excel Ribbon: Change a control's default screentip/supertip

    Some built-in controls (eg, idMso="FileSaveAs") allows customization of the screentip and supertip properties. Others, such as idMso="CellFillColorPicker" apparently do not. Is there a way to override these properties? TIA John
  4. A

    Replace or override sub code

    Hi! so I'm very new with Vba in excel. i have a code that sends specific data (from excel files) to an access database. i wrote a code that loops through several hundred files and sends this information. The problem is to manually update these files, it is sent with a button. I need to override...
  5. C

    VBA Help with copying from sheet to Sheet with Validating list

    So I have hit a brick wall with my project I am working on in Excel. Here is my scenario for example I have a worksheet with a list of 17 questions with answers based on a validation list. My client would like to have the answers copied over to Sheet2 which is not a big deal however they want...
  6. kelly mort

    Delete file in a folder with vba or override with new file

    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim backupfolder As String backupfolder = "C:\BackupFile\" ThisWorkbook.SaveCopyAs Filename:=backupfolder & ThisWorkbook.Name End Sub Hi, The above code is what I am using to create a backup of my...
  7. P

    Form Textbox to only allow certain values

    Hey, I have a textbox on my form that manually has values entered based on a Truth Table however, I want to be able to override these fixed values and then input my own if applicable. I have an override button that activates the manual entry into these boxes however, I'm having trouble on...
  8. K

    VBA to override typed workbook name on save

    Is there a way to write a VBA code in a sheet that will override any name a user enters when a workbook is saved? I want the sheet to pull the name from a cell instead of accepting the name they type in because they never name the file properly.
  9. S

    Delete Rows

    Greetings, I have been looking through the forums for an example, but i can't find exactly what I am looking for. I am looking for VBA to run through my sheet and remove rows that contain a certain keyword (override) in a certain column (F). The thing that is tripping me up is that the...
  10. sharky12345

    Add extra COUNITF to formula

    I've got this formula that I need to expand if someone can help; I need it to check O2:O42 and if C2 is found I need it to show "Abstracted" - this should override the "YES" or "NO" part if possible.

    How to Override Conditional Formats

    I hope I can explain this situation in an understandable way. I'm using Excel 2007. For several columns I have conditional formatting (fill cell with white) if it contains the high or low value within a range in that column. There is a row for each date (day) of the year. A 1st-time (&...
  12. M

    Overriding Macros

    Hi, I currently have a simple macro (see below) that requires users to input values in specific cells, otherwise it will not print or save. However, I need to be able to leave the values blank before saving and sending to the user. Any suggestions? I want to be able to save with blank cells...
  13. N

    VBA - override autofilter warning message

    Good evening guys, Just a quick (I hope) question: I'm creating a tool to use at work. It will essentially perform an autofilter operation. The thing is that I want the results to be only 5, so that's the limit I have in my destination range and, if by any inexplicable reason, someone search...
  14. H

    Warning when overrides PDF

    Hi, I have the following code for saving as PDF: Private Sub LagrePDF_Click() Application.DisplayAlerts = True If Sheets("Lister").Range("BQ3").Value = "x" Then If Sheets("Rapport").Range("AE6").Value = "" Then Call PdfGnrBnr Else: Call PdfGnrBnrFnr End If Else...
  15. Jaafar Tribak

    Overriding Excel Methods and Properties (VTable hacking)

    Hi all, I have been reading on the layout of COM objects and Virtual Tables and I have managed to hack Excel Methods and Properties .. It's surprisingly easier than I had thought but just as I was getting excited about this idea and it's enormous potential for adding new functionality to Excel...
  16. I

    Customize ALL 6 of Excel DEFAULT currency Options in currency drop down menu

    I have seen a lot of posts about how to establish the default currency option in excel, however I want to define all 6 of the first currencies in the currency drop down menu. With the defaut region set to the US, the five currencies listed are: $ English (United States) £ English (United...
  17. F

    Pop up question if data already exists

    Hi I have a excel sheet that users use to input data in to table. The following data that user has to input is: Column B= Name C= Quarter D= Year etc.... What I want is when user puts in a name, quarter and year and more information excel checks if following data(Name,Quarter and Year)...
  18. dukeofscouts

    Stopping Message boxes

    I have to macros that I use very often, both of these codes cause excel to display message boxes to be displayed. One is from a SAVE command, the other from a copy/paste command structure. I presume there is a way to turn these messages off, or write into the VBA to trick excel into thinking...
  19. G

    Override conditional formatting

    Hi All, My first post here, I am a bit of a novice at excel and a complete novice at VB and VBA so be patient with me. It seems a relatively simple problem, but I can't seem to find an answer. I am using Excel 2002 on XP with SP3. I have a large spreadsheet that for ease of reading I have...
  20. R

    Rank with Override

    Hi. I have a list of projects that each get assigned a rank based on different criteria. I then allow the user to override the assigned ranks if needed. The override column will only have values filled in where an override takes place. I then want to re-rank all of the projects accounting...

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