belly0fdesir
02-02-2006, 06:44 PM
I have this PTO calendar that I've been designing for my office, and everything on it was working smoothly, until I added a function that I found to Sum based on font color.
But now it isn't working correctly. I added a couple of buttons for users to click to change the color and then put the function in and called on it in a formula in column Summary!N6:N121. At first I was displeased because my entire workbook seemed to slow down and on top of that, the formula would not calculate unless I hit F9. But now, the buttons that I added to ease the user in changing colors aren't functional either. Can someone look at this to see what I did wrong?
The function that I added is in Module 2.
I have uploaded a copy of this workbook here (http://s59.yousendit.com/d.aspx?id=1AKKGZXVP1AJ71FN4843TZBB88).
If you can help in any way it would be very appreciated. Thank you.
-Belly
But now it isn't working correctly. I added a couple of buttons for users to click to change the color and then put the function in and called on it in a formula in column Summary!N6:N121. At first I was displeased because my entire workbook seemed to slow down and on top of that, the formula would not calculate unless I hit F9. But now, the buttons that I added to ease the user in changing colors aren't functional either. Can someone look at this to see what I did wrong?
The function that I added is in Module 2.
I have uploaded a copy of this workbook here (http://s59.yousendit.com/d.aspx?id=1AKKGZXVP1AJ71FN4843TZBB88).
If you can help in any way it would be very appreciated. Thank you.
-Belly