Re: Formula Causes Sheet To Ask "Save Changes?"

This email is to be read subject to the email disclaimer
located at www.tarongenergy.com.au
 
 
In my battle against hardcodes, can I suggest you try this

Put this sub routine in your vba

Sub Writedate(cellRow As Integer, cellCol As Integer)
    Cells(cellRow, cellCol) = Today()
End Sub 

Then have a macro in "this workbook" that runs on
start up that has this
in the code. 

Writedate 1,1

'This will write the today info in the cell A1 each time you
open. You
could run this off a button if you didn't want it to 'update
each time
you opened.

Then reference your formula to A1. 

I hate harcodes.
Hope that helps.
Toby



-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On Behalf Of Derby Dad
Sent: Tuesday, 30 January 2007 1:48 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: Formula Causes Sheet To Ask "Save
Changes?"

Thanks. I guess I'll hardcode the current year and let it
run until next
year.


On Mon, 29 Jan 2007 15:41:16 -0000, Jon Tydda
<Jon.TyddaALCONTROL.CO.UK> wrote:

>It's because the today() function updates everytime you
open the 
>spreadsheet, so you ARE making a change.
>
>
>Jon
>
>-----Original Message-----
>From: Derby Dad [mailto:d.marulliEZNET.NET]
>Sent: Monday, January 29, 2007 2:54 PM
>To: EXCEL-GPEACH.EASE.LSOFT.COM
>Subject: Formula Causes Sheet To Ask "Save
Changes?"
>
>
>I'd like to know why this formula causes a workbook to
always ask me if

>I want to save changes, even when no changes have been
made.
>
>I have a single sheet workbook that I use as a template
for collecting 
>client data. After I enter the data, I save the sheet
under the 
>client's name.
>
>In L6 I have this formula: 
=IF(H6>0,YEAR(TODAY())-YEAR(H6),"")
>
>H6 is empty when the "template" is first
opened. After I enter a 
>birthday in H6, the formula returns the age the person
will be this 
>year. I use the IF function so that the Age cell (L6)
doesn't show 107 
>when the birthday cell (H6) is empty.
>
>If I open the original workbook (or a client's workbook)
I can't close 
>it without responding to the "Save Changes?"
dialog box even though I 
>have not physically changed anything or even selected a
cell. If I 
>remove this formula, the problem goes away.
>
>How can I accomplish the same goal without the
workbook(s) thinking 
>something has changed?
>
>--------------------------------------------------------
---------------
>--- The EXCEL-G list is hosted on a Windows NT(TM)
machine running 
>L-Soft international's LISTSERV(R) software.  For
subscription/signoff 
>info and archives, see 
>htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
>http://peach.ease.lsoft.com/scripts/wa.
exe?SHOWTPL=COPYRIGHT&L=EXCEL-
G
>
>
>The information in this e-mail is confidential and may
also be legally 
>privileged. The contents are intended for recipient only
and are 
>subject to the legal notice available on request from :

>webmasteralcontrol.co.uk ALcontrol Laboratories is
a trading division
of ALcontrol UK Limited.
>Registered Office: Templeborough House, Mill Close,
Rotherham, S60 1BZ.
>Registered in England and Wales No 4057291
>
>--------------------------------------------------------
---------------
>--- The EXCEL-G list is hosted on a Windows NT(TM)
machine running 
>L-Soft international's LISTSERV(R) software.  For
subscription/signoff 
>info and archives, see 
>htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
>http://peach.ease.lsoft.com/scripts/wa.
exe?SHOWTPL=COPYRIGHT&L=EXCEL-
G

------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G