Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert date then lock cell!
Hi, Is it possible to have the formula =TODAY(), but when entered into a cell is then locked, so it doesn't alter the following day. I want a button that when clicked, enteres this formula into the selected cell, but once entered I want the cell to then lock so the date does then not ever alter. Can this be done? Thanks, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494762 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert date then lock cell!
Don't use a formula. Just plop the date in directly--something like this in
your buttonclick code: with activecell .value = date .numberformat = "mm/dd/yyyy" end with mevetts wrote: Hi, Is it possible to have the formula =TODAY(), but when entered into a cell is then locked, so it doesn't alter the following day. I want a button that when clicked, enteres this formula into the selected cell, but once entered I want the cell to then lock so the date does then not ever alter. Can this be done? Thanks, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494762 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert date then lock cell!
Will give it a go, thanks. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494762 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert date then lock cell!
Hi, another quick way to insert todays date in the selected cell is to simply hit the CTRL + ; keys. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=494762 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert date then lock cell!
Cheers Dave, got it working and it's just the job. Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494762 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Date Range within one cell | New Users to Excel | |||
How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
Adding a control button to insert a date in the active cell. | Excel Discussion (Misc queries) |