Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a file that I would need certain cells to be cleared out when the file is opened for the first time during the day!!! What the file does is basically for my employees asking to leave earlier, they add their name to the file, save it and close it. I want to have a macro that will run everytime the file is opened and if you are the first person opening it today (so basically if the last time it was saved was for yesterday's date), I would like to have certain fields to be cleared... If any one know of a way to do this, it would be great... Thanks!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cells.Clear | Excel Discussion (Misc queries) | |||
clear contents cells of unprotected cells | Excel Programming | |||
Clear Cells | Excel Discussion (Misc queries) | |||
Clear cells with #N/A | Excel Programming | |||
Clear cells range if certain cells are all empty | Excel Programming |