Prompt For Save When No Changes Made

Dec 10, 2004

I have an excel spreadsheet that when opened and closed prompts to save changes, even when no changes have been made.

The spreadsheet is a copy of another spreadsheet which has then been modified. The original spreadsheet doesn't have this quirk.

There are no 'links' in the spreadsheets. Which was my first thought.

View 9 Replies


ADVERTISEMENT

Workbook Asking To Save When No Changes Made

Mar 1, 2013

I have made some changes to a workbook and now every time I want to close it I'm asked if I want to save the changes, even when I have made no changes. If I click 'Yes' to save changes the problem still occurs the next time it's opened & closed.

I have checked external connections and there are none. I have done a 'find' to check that there are no formulas looking at another sheet, which I cannot find.

This document has to have a live calculation function - I have read some suggestions around turning off auto calculations but this isn't a possibility and I'm not sure that this is where the problem lies.

The previous version does not have this problem, so it is something I have done between v2.2 and v2.3. I have attached both for reference. Note that they were originally xltm's not xlsx's - I could not upload macro-enabled templates, but the same problem occurs in v2.3 in this format.

View 3 Replies View Related

Trigger Before Close Macro Only If Changes Have Been Made Since Last Save

Jul 2, 2013

I am using the...

Private Sub Workbook_BeforeClose(Cancel As Boolean)

... to capture when a user is about to close a workbook. I then give them a message: "Are you sure you want to exit? Changes you made since you last saved will be lost."

However, to make it neater, is there a way to only trigger the macro if they have made changes since the last save? In other words, if they have not made any changes since the last save, the message will not be displayed, since it is irrelevant.

View 2 Replies View Related

Prompt Where To Save

Jan 10, 2007

Currently I have information that includes numerous distributors information on one sheet. The code below separates each distributors information into a new tab and a new workbook, names the workbook and saves it in the specified file path.

I am trying to figure out a way to use an InputBox to popup and ask the user where all the new workbooks will be saved at. Thus, avoiding the need to change the code each time you want the new workbooks saved in a different folder .....

View 9 Replies View Related

Stop Save Prompt

Feb 11, 2005

I have a spreadsheet that has hyperlinks in it and is mostly protected to prevent changes. Is there a way to prevent the "save changes" dialog box from appearing when this file is closed as I have to make this file available to others and don't want them to get this message or make save any changes.

View 7 Replies View Related

VBA To Save As In Specific Path With Prompt

Oct 6, 2011

I'd like a macro that will:

Save my workbook
Then
Open the SaveAs box with the path already pointing to a specific directory and with the Name and file format already entered (.xls)

This is basically to save time navigating through our folder structure (which is a real mess). I don't want to automatically saveas the file as the target folder will change each month and the last part of the file name will chance (month). So I'd like a bit of flexibility rather than total automation.

View 3 Replies View Related

Close Application Without Save Prompt

Nov 14, 2006

Is there a code I can use, through a private command button, that will exit the Excel program (not just the current workbook) without asking to save?

View 3 Replies View Related

VBA - Go To Website And Download File From Save Prompt

May 24, 2013

How to save a file onto the computer using VBA. The code template below that I found on another forum seems promising, except when I go to the desktop to access it, the .csv file has what looks like the page's source code instead of the actual file I want. This may be because when I go to the url, it doesn't automatically download the file; rather, I am asked to save the file to a certain location (since I don't know the path name of the uploaded file on the site).

Is there any way to alter this code to accommodate this, or will I have to use a different code entirely?

VB:
Sub Test()
Dim FileNum As Long
Dim FileData() As Byte
Dim MyFile As String
Dim WHTTP As Object

[Code] .....

View 9 Replies View Related

Macro To Prompt For Save Location And Filename

Feb 22, 2014

In a workbook, I use a macro to extract a sheet and save it as xls.

What code should I use to prompt the user to define the location and name of the new file to be saved?

View 1 Replies View Related

Automatically Prompt To Save Template When Opened

Jun 4, 2008

Is it possible to open a template, prompt the user to enter data and have the template save itself as the user defined data?

View 5 Replies View Related

How To Call Save As Prompt If Directory Doesn't Exist

Apr 1, 2014

I am using this code to generate a text to a directory, but I would like to know how to call a save as prompt if the directory doesn't exist?

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

If the folder macro does not exist, then it will prompt a message saying that the folder macro cannot be found, and the save as prompt will appear.

View 3 Replies View Related

Save As Macro With Location Prompt But Fixed File Name ?

Dec 29, 2008

For a sheet that many non-expert users will use on different systems I need a macro that let's them save, print and send the results of their work. So I made a macro that makes a copy of only 1 sheet of the workbook and saves it with a given name to a given location. The problem is that I want a location prompt to ask the user where they want the file saved, while giving/suggesting them a fixed filename. A lot of different users will make and use their sheets so I need a certain naming policy to manage all the files. (date, location, etc)

View 4 Replies View Related

Clone Active Worksheet And Prompt User For Where To Save CSV

May 29, 2013

I've recorded this code and am looking to include it in a button. I would like for when a user clicks the button assinged macro that the active sheet is cloned and saved as a CSV file. The user should be prompted before saving on where (file location) they'd like to save the file.

Sub CloneWorksheet()
'
' CloneWorksheet Macro
'
'
Sheets("SDW&Customer Workshop scheduled").Select
Sheets("SDW&Customer Workshop scheduled").Copy
ActiveWorkbook.SaveAs Filename:= _
"C:Documents and Settings1167916My DocumentsTestBook1.csv", FileFormat:= _
xlCSV, CreateBackup:=False
End Sub

View 9 Replies View Related

Prompt Users To Enter Information In Specific Range Of Cells Before Save

Mar 11, 2014

Is there a way to prompt users to enter information in a specific range of cells before they save?

View 1 Replies View Related

Prompt User For Directory And Filename; Then Save File In Directory With File Name

Jun 10, 2009

I am trying to prompt the user for the directory to be saved in and file name to be saved as; then save the workbook in the input directory with the inputted file name.

View 3 Replies View Related

Notification Of Changes Made To A Spreadsheet

May 8, 2014

I have a master spreadsheet being updated by several people, how can I/we, get a notification set up for when ever someone updates the master spreadsheet.....

View 1 Replies View Related

Having A Macro Run If Changes Are Made To Certain Cells

Mar 31, 2009

Is it possible to write a macro that will run if a user enters data into any cell in the worksheet that has a formula in it.

View 9 Replies View Related

Can # Of Results Be Made Variable

Jan 2, 2010

I am using Excel 2003, with Windows XP. I am monkeying around with a form to allow my boss to randomly assign employees to a daily task. There is a list of 15 names, but I'm just using the numbers 1 through 15 until I get the hang of this formula.

I am using MRAND, and the formula is working perfectly when I specify a set # of values to deliver. I wanted to see if I could allow him to enter the # of employees he wants to task in Cell A1 so that the number of random employees that are assigned varies with his selection in A1.

In other words, one day he could specify he wants 3 randomly assigned names to work on the task and the next day he could randomly assign 6 names/people, etc...

I thought I could just plug $A$1 in "maximum" in the formula below:
{=MRAND(maximum,1,15)}

But that's giving me a #NUM! error.

View 11 Replies View Related

Followup Made By Salesman Between Particular Set Of Dates?

Sep 19, 2013

I am trying to analyse, in a set of data that how many followup made by a salesman between a particular set of dates. I've attached a sample. In this example I differentiate between people if the name and age are same. I know that it is possible with formula 'countifs' but how?

View 3 Replies View Related

Sub To End And Select The Cell Where The Correction Needs To Be Made

Jan 19, 2009

I need to step out of a macro based on a user respone, and I don't know how to end this macro if the user needs to correct a cell entry.

If they respond "no", I want to sub to end and select the cell where the correction needs to be made.

View 8 Replies View Related

Delete Cells When Any Changes Have Been Made To Sheet?

Jun 27, 2014

I've tried for a while on my own but no luck. I'm looking to delete cells D21 and 22 when any changes are made to the sheet.

I've tried using Private Sub Worksheet_Change(ByVal Target As Range) but no luck.

View 5 Replies View Related

Automatic Update Of Data If Changes Made

Jul 1, 2014

The workbook I have has a tab for Master List of Transactions - there is data in columns A through J. In column E, when a year is entered, the data in columns A through D is copied to a tab for the specific year entered in column E. When the data from columns A through D is copied to the specific year's tab, it does not change anymore. If the information is changed at all on the Master tab, the macro does not currently work to automatically update the information on the specific year's tab but I would like it to. Is this possible?

Here is the macro I currently have:

Private Sub Worksheet_Change(ByVal Target As Range)
' Code goes in the Worksheet specific module
Application.ScreenUpdating = False

Dim rng As Range
Dim row_copy As Integer

[Code] ......

How to automatically update the year tabs for changes on the Master List of Transactions tab.

View 1 Replies View Related

Automatically Goal Seek Whenever Changes Are Made

Oct 18, 2003

I have created the following in an effort to automatically goal seek whenever changes are made to the cell C2.

Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Row = 3 And Target.Column = 2 Then
Range("D19").GoalSeek Goal:=Range("C2").Value, _
ChangingCell:=Range("D3")
End If
End Sub

As far as I know, the Macro is running all of the time? When I use goal seek manually it works fine. Assuming the above is running, when I change the value in C2 nothing happens. Does the fact that I have a three sheet workbook make any difference? I am sort of lost. By changing the value in C2 I want Excel to change the value in D19 to match C2 by adjusting D3.

Application.EnableEvents = False
Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Row = 3 And Target.Column = 2 Then
Range("D19").GoalSeek Goal:=Range("C2").Value, _
ChangingCell:=Range("D3")
End If
End Sub
Application.EnableEvents = True

Doesn't seem to work either. However, I don't really know if other settings in the workbook are correct.

View 9 Replies View Related

File Size Made Smaller

Apr 20, 2006

Is there a way of eliminating un-used rows & columns to bring your file size down.

I already know about eliminating unnecessary pages, and I've cleaned up defunct modules, etc., and anything else that's just clutter.

The Row & Column thing would be a big help.

View 7 Replies View Related

Macro To Stop If No Selection Made

Jun 14, 2007

If nothing is typed in and the OK button is pressed, it changes the entire sheet to values. I'd like the macro to stop if nothing is selected.

Dim sCol As String
sCol = InputBox("Select Column")
Set UserRange = Range(sCol & "9:" & sCol & "35")
UserRange.Value = UserRange.Value

View 6 Replies View Related

Reference Shape Made With BuildFreeForm

Jan 4, 2008

How do I select a shape I have just created with BuildFreeform function? It is not convenient for me to reference the resultant shape as I have done below:

Public Sub DrawDoor(TileType As String, Xpos As Integer, Ypos As Integer)
With ActiveSheet.Shapes.BuildFreeform(msoEditingCorner, Xpos * 9 + 1, Ypos * 9 + 5)
.AddNodes msoSegmentCurve, msoEditingAuto, Xpos * 9 + 5, Ypos * 9 + 1
.AddNodes msoSegmentCurve, msoEditingAuto, Xpos * 9 + 9, Ypos * 9 + 5
.AddNodes msoSegmentLine, msoEditingAuto, Xpos * 9 + 9, Ypos * 9 + 10
.AddNodes msoSegmentLine, msoEditingAuto, Xpos * 9 + 1, Ypos * 9 + 10
.AddNodes msoSegmentLine, msoEditingAuto, Xpos * 9 + 1, Ypos * 9 + 5
.ConvertToShape
End With
Shapes(8).Fill.ForeColor.RGB = RGB(200, 90, 20)
End Sub

I want to give the shape a name, without having to use Shapes(8) at any stage. Is this possible when making freeform shapes?

View 3 Replies View Related

Number Of Calls Made By A Person In A Month

Sep 5, 2013

The first column is "Person Name" and the second column is date in format "6/27/2013". I want a formula to calculate the total number of calls a person made in the month of June.

View 2 Replies View Related

Finding How Many Words Are Entirely Made Up From Characters In Field?

Jul 16, 2014

i bought a tattslotto scratch card (for those of ya outside of australia, not sure what youd call em, basically lottery ticket/game), this game is essentially a crossword puzzle, you scratch your letters out in a box then you have a list of words, you need to find words that are made up entirely of your letters, the more words you find, the more you win ive kind of screwed up the card and scratched out words i dont have, however i do have atleast 2 words and i think ive got more, potentially could win big but wanna know how much before i go claim it

ive opened up a new workbook, in the A column ive got a list of all my words, then in C1 ive got a field where ive entered all my letters, wondering if theres a way to get excel to work it out for me (like an IF statement on the fields in column A to compare them to C1, or some kind of conditional formatting rule)

View 1 Replies View Related

Get Focus Set To A Certain Cell And Made Active On The Same Page

Oct 29, 2008

I made a command button on the worksheet from the Tool box. This is not made on a form. When I click on the button I would like to get focus set to a certain cell and made active on the same page. Like cell H2 for example.

View 2 Replies View Related

Search For Payments Made In A Certain Month And Return The Sum

Sep 14, 2009

How can I search a range of cells that have a date entered by hand for a certain month and then sum the amounts given in another range of cells. For example, search several worksheets for payments made in September and then return the sum of those payments.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved