Prevent Save Option If Condition Not Met

Sep 28, 2006

I have a list dropdown from cells A2 to A10. If only when a user selects "orange", he has to key in some description in column B.

Eg if he selects orange in A2, he has to key in some description in B2.

Is it possible to set some formula or macro which prevents user to save this file if he leave blank in B2 or B10, depending on which row he has select "orange"?

View 8 Replies


Prevent Click On Check Box If Condition Met

Oct 20, 2006

I have two check boxes in a worksheet created from the "Forms" toolbar.

Is it possible to prevent a user from clicking these two check boxes if he meet a condition in cell A1.

Eg, If cell A1 value is "Marketing", the user is not able to click on these two boxes.

View 9 Replies View Related

Prevent Data Entry If Condition Met

Jun 4, 2007

I am adding up the value of a range of cells in one cell. What I want is If the value of the cell which is adding up the values of the range of cells exceeds a particular number it should throw an error.

View 6 Replies View Related

Prevent Saving Of Excel If Certain Condition Not Fulfill?

Feb 7, 2014

I want this statement translated into a macro.

Do not save file year.xlms if total of column N in sheetR does not match with total of column O in that sheet. I also want a msgbox if this happens.

View 4 Replies View Related

Save Option Off The File

Dec 11, 2003

I want to be able to take the save option off the file in my macro to stop any user whos using the spreadsheet from saving full stop.

Is there a code where it will totally disable the save function, I have tried using the code for workbook protection, however this still aloows one to save.

View 9 Replies View Related

Exit Without Option To Save

Sep 8, 2005

Is there anyway I can make excel quit using VBA without the option of saving the changes popping up?

View 5 Replies View Related

Prevent To Only Save On Specified Workbook With VBA

Jan 28, 2013

am trying to create a workbook template which collects data from users with user forms and some macros. Users assign a project name when workbook opens and then they are able to save as the workbook with name of project name. But i don't want them to save on my template mistakenly. How do i prevent this? I tried workbook_before close sub but i can manage that it recommends to save workbook with project name and if you don't want, it still asks you if you want to save workbook before close

View 7 Replies View Related


Nov 28, 2007

I want to make sure that the user of a file only saves from a button on a particular sheet. Can I ensure that if the user goes File Save at any time that they cannot use it?

View 9 Replies View Related

Macro To Prevent 'save-as'

Feb 21, 2002

Is there any way to write a macro which can prevent computer illiterate users from saving their files EVERYWHERE??

View 9 Replies View Related

How To Prevent SAVE In Word

Jan 29, 2009

how to prevent a user saving a Word Document.

View 9 Replies View Related

Disable Save Query Definition Option Vba

Jan 25, 2007

I want to be able to disable the save query definition option for a worksheet using VBA. Right now I have to right click a cell and then go to Data Range Properties and then uncheck the save query definition box. If there is a way to automate this that would be great.

View 3 Replies View Related

Save Today() As Value To Prevent Changes On Reopen

Jul 30, 2008

I have a spreadsheet that containt a conditional formula to place the current date aka Today() into a cell based on if an entry in the previous cell.

I put in this formula:
=IF(I131>="1",TODAY()," ")

My boss told me to update to this one: (same result)

BOTH will change the saved sheet data if we open it tomorrow (due to using Today()). We want to retain the date that it was entered on (which will always be the date he puts entry into sheet).

Is there a way to save the sheet and update the code for Today() to the date value so it will appear as a date when it's opened in the future?

View 9 Replies View Related

Prevent Save As Version Message

Oct 17, 2006

I have an extensive application which I wrote using Excel 2002 (XP - Version 10). However it will likely be used on anything ranging from 2003 - 1997. When I tested it using Excel 97 it gave me the traditional [annoying] message asking if I was sure I wanted to save it under an earlier version than which it was created.

I want to get rid of this message (a lot of my users aren't the most computer literate and the more annoying messages I can avoid the better!)
I tried using:

Application.DisplayAlerts = False

but it doesn't affect this particular message. I need to know how to keep this message from popping up. Please Help.

Under 97 (NOT on my 2002) it also gives a "Do you want to save the changes" message upon closing even though the "DisplayAlerts" is set to false. I'm not sure why this is still coming up.

View 9 Replies View Related

Prevent Saving Certain Worksheets On Save As

Jan 19, 2008

In my program I have prevented the user from saving the Workbook with the following code

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim p As String
Cancel = True
Do While Cancel = True
p = InputBox("Enter password to save file:", "Password Required To Save", "")
If p = "Enter Password Here" Then
Cancel = False
yn = MsgBox("Wrong password. Try again?", vbYesNo, "Invalid Password")
If yn = vbNo Then
Exit Sub
End If
End If
End Sub

I also need to prevent the user, when they use the save as, from saving certain worksheets. Ex: There are 6 worksheets in the workbook. I only want them to be able to save the first three. Issues: One of the workbooks that I want to allow them to change has a tab name that changes frequently.

View 2 Replies View Related

Prevent Workbook Save But Allow SaveAs

Jun 24, 2008

I've got a workbook that I want to keep intact in a central location on our local network, to make it easier for everybody to access, but don't want people to be able to save changes to the master workbook itself. I'd like to be able to disable the 'Save' feature while still allowing 'SaveAs'. The following code (installed in ThisWorkbook) results in the OPPOSITE of what I'm trying to accomplish (i.e., it allows 'Save' but disables 'SaveAs'):

Private Sub Workbook_BeforeSave(ByVal SaveUI As Boolean, Cancel As Boolean)

If SaveUI Then
MsgBox "The 'Save' function for this workbook has " & Chr(10) & "been disabled. Please use 'Save As'.", vbOKOnly + vbInformation, "Save Disabled"
Cancel = True
End If

End Sub

Obviously I'd also like to check the filename they're performing the 'SaveAs' under and disallow it if it matches the master filename.

I've thought about making the workbook into a template, which would sort of accomplish the same thing, but it would be much easier to just keep it as a workbook.

View 9 Replies View Related

Excel 2007 :: How To Initiate Auto Save Option

Apr 18, 2013

I want to know what is the way to auto save our excel sheet data ?

View 3 Replies View Related

Prevent Save Until Save As Used

Mar 21, 2008

I am trying to hide/grey SAVE option from the menu bar and reset menu back to normal after Save AS has been used.

I was able to do disable SAVE using the following code.

Application. CommandBars("worksheet menu bar").Controls("File").Controls(4).Visible = False


the SAVE icon on the Standard toolbar still exist. Is there any way I can disable it and also prevent CTRL. S being used.

Second part of the question.

Once I use Save as I would like menu to be reset back to normal.

View 5 Replies View Related

Prevent Hidden Columns From Showing Up When I Save It As A Txt File.

Mar 20, 2009

When I am saving my spreadsheet as a text file, I have 1 column with formulas that I would like to not show up in my text file. I have tried hiding the column, and have Googled for awhile now.

View 2 Replies View Related

Macro To Hide Cut,copy,paste,save,saveas Option In Word

Feb 15, 2007

I want to restrict users to just read or print a word document. Document is very confidential so we dont want them to copy or manipulate the document.

I thought of giving password to restrict to read only option but that still lets users to copy and paste on to a new document.

View 9 Replies View Related

Disable The "Save" Option From File Menu And Allow Only To "Save As"

Sep 24, 2002

How do I disable the "Save" option from File Menu and allow only to "Save as"?
Excel 97/2000

View 9 Replies View Related

Excel 2013 :: CF With 2 Option Buttons / Multiple Option Groups?

Sep 6, 2013

I have several option groups (Y & N in each) linked to cells to display TRUE / FALSE depending on which option is selected in each group. I have another cell which I want to apply conditional formatting to if EITHER Y or N is selected in all groups. At present I use COUNTIF to check for FALSE=0 in the linked cells which works if all the answers are Y. How do I apply CF if there is a mixture of Y & N (TRUE / FALSE) in all groups (I'm not sure if I've explained that well or not).

Excel 2013

View 1 Replies View Related

Prevent Save Unless All Cells Or Certain Cells Are Filled In

Dec 2, 2007

I have a spreadsheet that is emailed to someone to fill in. They then fill in some information and send it on to someone else.

Sometimes they don't fill in all the information so is it possible to have excel check that cells are filled in and to prevent someone from saving unless this is so? Or maybe a message stating that the cells need to be completed if Excel is being closed or saved?

View 11 Replies View Related

Save Conditional Format Colour But Delete Condition Format

Dec 19, 2006

I have a Sheet ( Named "Summary" for Example ) of about 4,000 Rows that has a LOT of Conditional Formatting.

I Added Another 100 Rows this Morning and when I Tried Saving it a Message Saying that Not All the Formatting for the New Data that had Been Added had Been Saved. Is there a Macro or Something I can Run that will Make the Conditionally Formatted Cells Stay the Colour that they are but Delete the Conditional Formatting Part of it Achieved Using "Format" & "Conditional Format" from the Menu Please.

Ideally I would like to be Able to Enter the Number of Rows ( From Row ? to Row ? ) that I want this to Apply to.

View 9 Replies View Related

Lost The File Menue Option That Allows A File "Save As"

Apr 4, 2006

I have upgraded to Excel 2003 and have lost the File menue option that allows
a file "Save As".

View 9 Replies View Related

Cell Equals 0 Changes When Condition Met - Leave Unchanged When Condition False

Mar 24, 2014

I am trying to perform a calculation in a cell that leaves the value 0 if before Feb 2014, changes to the value of another cell in Feb 2014 and leaves the value unchanged if after Feb 2014. I can get to the Feb 2014 value but after that month the value changes to 0.

The Cell formula that I am trying to use is as follows:


A3 contains TODAY()

H114 is the cell being calculated

AA118 is the cell containing the calculated value for the current month.

View 2 Replies View Related

Multi Condition Format? Lookup And Date Condition Valid For

Aug 13, 2009

I would like to try and achive a conditional format that will require a lookup function. when the condition is met it places Yes or No into a cell and changes that row colour to red for the NO condition. and after 10 days from now the rowcolour is removed.

View 6 Replies View Related

Conditional Formatting :: Condition 1 Override Condition 2?

Feb 29, 2008

I'm having trouble with the two formulas working in conjuction with each other.

Condition 1:

Condition 2:

"Condition 1" seems to override "Condition 2"? Ever see that?

View 9 Replies View Related

How To Count Condition Based On Having Another Condition

Apr 12, 2014

So I have one sheet that needs to pull data through to another sheet (which is a stats summary)

I have a drop down list containing 4 options all of which have to be counted separately on the stats summary sheet. However I only need them counted when a value is input in another cell in that row.

For example: I select option 1 from down down menu, but I only want this to be counted on the stats page when I enter a date in the "date" cell.

View 9 Replies View Related

Return Values Of Adjacent Cells When Condition Is True Omitting Values Where Condition Is False?

Jan 15, 2014

Here's a simplified example:




[Code] .........

I'm looking to return the values in column A adjacent to the cells in Column B equal to "Y". The kicker has been returning only the cells where the condition is true. Column C displays the desired behavior.

The closest I've been able to get is with a simple IF statement but I'm pretty sure the answer is a far cry away from there and likely requires an array formula. I'd prefer not to use VLOOKUP or OFFSET but will if the alternative is very complex.

View 7 Replies View Related

Excel 2010 :: Save Open Worksheet To File And Include Date Of Save?

Mar 11, 2014

am using Excel 2010 and having issues trying to save a worksheet to a specified file location with the save date....

I have tried several posts form this forum and elsewhere and can't seem to get the macro to do what I want.....

I want to save a 'worksheet' from an open workbook that I use for updating information to the same file path as the workbook with the date the file saved...

View 6 Replies View Related

Copyrights 2005-15, All rights reserved