Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Making a auto date entered into a cell permanent from a template
Hi
I have a quotation template that I want to have the date automatically entered into a cell when the New file is opened. This will be the date the quotation is created. That is easy however what I require is when the file created from the template is saved and opened at a later date the date does not change from the origional date that was entered and can not be altered by the user. It is in a locked cell. Any one have any ideas |
#2
|
|||
|
|||
a little macro which copies =today and pastes as a value on top of itself
based on a worksheet change or before save event? -- paul remove nospam for email addy! "Muncher" wrote: Hi I have a quotation template that I want to have the date automatically entered into a cell when the New file is opened. This will be the date the quotation is created. That is easy however what I require is when the file created from the template is saved and opened at a later date the date does not change from the origional date that was entered and can not be altered by the user. It is in a locked cell. Any one have any ideas |
#3
|
|||
|
|||
Thanks Paul,
I have tried this earlier but how do you do this when the cell is protected/locked and if it is based on a save macro wont it update each time you save the file thus changing the date. "paul" wrote: a little macro which copies =today and pastes as a value on top of itself based on a worksheet change or before save event? -- paul remove nospam for email addy! "Muncher" wrote: Hi I have a quotation template that I want to have the date automatically entered into a cell when the New file is opened. This will be the date the quotation is created. That is easy however what I require is when the file created from the template is saved and opened at a later date the date does not change from the origional date that was entered and can not be altered by the user. It is in a locked cell. Any one have any ideas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function making cell really "empty" | Excel Worksheet Functions | |||
Trying to make cell "date sensitive" to specific date | Excel Discussion (Misc queries) | |||
assign auto number and auto date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |