| 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 |
| 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) | |||
Threaded Mode
