Now I'm Really Confused

  • Thread starter Thread starter doss04
  • Start date Start date
D

doss04

I have followed the formulas given for clicking a cell and the time or date
appears. it worked for a few days. I opened my workbook to start using some
of the forms i made and the time and dates don't show. When i open the code
window, the formula is still there. Did i miss something?
 
Rule out calculation mode being inadvertently set to Manual. Take a moment to
check that calc mode is set to Auto, via clicking Tools > Options >
Calculation tab.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
 
Thanks that worked. Another question if possible. the cells are set for time
when i click on them which is what i wanted. The problem i am having now is
if i click on one of the time cells by mistake. (ie. i dont need the time in
that cell at that time). When i clear it, it erases the formula in that cell.
Any ideas?
 
This is what I have for 2) of my docs.
The 1st doc
A B
5 START FINISH
6
7
8
9
This doc is one click time. Some times the finish isn't on the same line.
the date is for a seperate cell

The 2nd doc
A B C D E
1 DATE ACCT# ARR CLR TOTAL
2
3
4
5

Again the ARR and the CLR is the concern. If I accidently click on the ARR
/ CLR cells and dont need the cells,The whole formula is gone.

tried a double click in the beginning it didn't work maybe i missed
something from the post.
 
Back
Top