Eldredge,
I am not sure exactly what you are trying to do, however I think this would work. Record a macro that simply selects the region where you have the NOW function used, and then use paste special/values to place the times as values in the cells where you want it to not update. THen...