prevent

Hello. I'm trying to prevent the users from saving the file as a new one if they have left some cells blank. What syntax do I use? Thanks!

I don't understand why it does that, I have a userform which inputs invoices into a table when I try to enter the invoice number (for example, 312650370010022819) it enters a changed number to the cell! (changes the example to 312650370010022000) Then I also have a feature in the initilize...

Is it possible to prevent users from adding the autofilter to Excel?

Hi all, I hope you can help me with this. I need a code to prevent that any external link or reference can be included in my Workbook. For example, I have my Workbook "Master" and someone wants to include in it a reference from another Workbook called "Country", let´s say in tab "Data", cell...

Hi, Is it possible to enable AutoCalculations (after I disabled its) by prevent immediate calculations until normally it would be executed (after some changes in worksheet is done?)

How to prevent a hidden column in excel from revealing?

Hello, It is my first post here, usually I'm able to sort out my issues with others posts -but this time i'm stuck. I'm just a beginner but trying my best to learn as much as I can. I have recently moved from excel 2010 to 365. I was using macro in "This Workbook" to simply prevent worksheet...

Hi, Could you help me with a case-sensitive formula that would prevent duplicate values based on two cells? Now I'm using this for column C: =SUMPRODUCT((--EXACT($C$1:$C$100000,C1)))<2 I need the same kind of thing, only it should evaluate column B as well. So, for example, Column...

I am trying to set the following VBA to prevent save if any checkboxes are empty. Any help is great. Private Sub dontsave() If Sheets("Sheet1").Range("A3") = "" Then Cancel = True MsgBox "Save cancelled" End If End Sub

I am puzzled by this issue. I have two cells that have the same exact value. However, when I take the difference between the result is not zero. instead, it's 6 -- see below. The culprit is cell B3. The result changes (..to zero, as it should be) when I click on cell B3 and press enter. I have...

I have an issue, where a column could have an "X" or any number from "2,3,4,5" in the cell. I need to prevent them from putting an X or anything else in the same column,so two x's would not be good, or two 2's, or even an X and a 2. That would be F18:F34 but the entire sheet is actually...

Hi, I have one sheet where almost all cells execute some macros by Worksheet_change event. Therefore I need to prevent all actions where user can change more than one cell at the time. I am going to use the code: Private Sub Worksheet_Change (byVal Target As Range) If Target.Cells.Count > 1...

Evening. I have searched the forum but could not find the answer. How do I prevent a formula when searching for a 1 picking up say 12 for example?

I am creating a survey in Excel 2013 and asking participants to rank 5 items. I want to create a drop down box next to each item with the choices of 1 2 3 4 5 NA but limit what they can select if they have already ranked another item in the list. Essentially trying to prevent them from being...

Hello Excel Experts, I really in need in your urgent help. I would truly appreciate any pointers or and any help with this code to that will be used to prevent a worksheet/workbook from being copied (shout out to yaseensallam for the code). #using Excel 2013 This code now works for a single...

I have same data points from equation =IFERROR(K3+Q3;""). When I plot these numbers and "" blanks into scatter plot, "" blanks are treated as 0 numbers. Is there any way to prevent that?

(sorry to start a 3rd post in 2 days...I'm dabbling in foreign excel territory and Google isn't helping). I have a worksheet that spreads over 2 pages. I have command buttons that insert rows as needed in various places. The worksheet is basically spread into 5 sections/categories of items and...

Hi, i want to prevent the user from doing Cut and Paste but to allow him to preform Copy and paste ( when they are doing Cut and Paste their getting Ref# error in formulas) when i use this code it prevents also the Copy and Paste which is needed by user and it doesn't do the Ref error...

Anyone know how I can type in 6E10 without excel converting it to a number? Thank you,

I have a file with an ODBC connection that works just fine on my windows computer. When my boss insists on using his mac to edit the file, the data connection is disabled. Not only is it disabled, I cannot get the connection back. So my question is...is there a way to prevent a mac from...