Is there a way to make a static date that does not change each time I reopen the spreadsheet? I'm basically trying to make a template for an invoice and I want the current date in it when I open it for the first time, but not to change so if I need to go back to it in the future. Thanks for any help in advance!
Then why not input the date manually?
Cheers!
Deep Dave
Because I want it to populate itself when I open the document. I can use the TODAY function but it changes the date everytime the spreadsheet is reopened.
If yopu dont want to enter it manually, and you dont want to use TODAY(), the only other option open to you is VBA
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Maybe some VBA,
Something like
It will put the date the 1st time the file is opened.. I'v assumed A1 to be the cell where the date is required.
Please Login or Register to view this content.
The Next time the file is opened, A1 wont be blank, and hence the code will not execute..
Last edited by NeedForExcel; 11-20-2015 at 02:07 AM.
Ctrl+Semicolon won't take much time to enter current date.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I cant use that because I want to make it autopopulate itself and then lock it so it is uneditable
@needforexcel, I have no clue how to do vba....little more advanced than I am
I'm actually surprised there is not an easy way to do this....just sounds like it would be kinda basic
The basic part, is that excel has the means to have a date updated, based on today's date. However, you cannot have it both ways, there is no way to "switch of" that function (other than set calcs to manual, but that is just a temporary fix, it will update/change the next time the file is saved/opened)
So your options are to enter it manually, or to use VBA to have it entered
is there a easy, good place to go to learn how to do that seeing as I dont know how to use vba?
NeedForExcel has already given you all the VBA you need..
VBA is my weak side, and no, there is no "easy" way to learn that, it is basically a programming language.
@kyle123 how do I put that into excel?
In your Excel Workbook, press Alt+F11 or Click on the Developer Tab > Visual Basic.
If your Developer Tab is not enabled, here is how to do it - http://www.needforexcel.com/#!Enable...7-85EDEE74C7C5
Double Click on this workbook (The Workbook which you are working on)
Capture.JPG
and paste the code there..
Capture.JPG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks