Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin

Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin

As I am rather new to excell how would I use the code to do this automaticaly
when the file is mailed or saved to a specific location?

Kevin

"Ron de Bruin" wrote:

Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin

More specificaly only when I mail it.

Kevin

"Ron de Bruin" wrote:

Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin

How do you mail it
FileSend To or with a macro

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
More specificaly only when I mail it.

Kevin

"Ron de Bruin" wrote:

Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin

I attace it to a mailing in outlook. my documents folder open and the mail
and just drag and drop.

Kevin

"Ron de Bruin" wrote:

How do you mail it
FileSend To or with a macro

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
More specificaly only when I mail it.

Kevin

"Ron de Bruin" wrote:

Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin

Then it is not possible.

You can use code to automatic insert the last saved date into the file.

Is that a option



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
I attace it to a mailing in outlook. my documents folder open and the mail
and just drag and drop.

Kevin

"Ron de Bruin" wrote:

How do you mail it
FileSend To or with a macro

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
More specificaly only when I mail it.

Kevin

"Ron de Bruin" wrote:

Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin