Re: Protecting a cell using VBA
I kind of figured that that would be the answer. I just wrote around it. I basically made a refreshsheet function that rewrites the appropriate functions and copies them down the appropriate columns or across the appropriate rows whenever it's triggered. The triggering event then is when the cell before the current active cell was one of those cells with a function. For rewriting the functions (almost 850 of them), copying them all, and recalculation, it's surprisingly quick. I started to just copy over the one cell that was active, but then found that if a series of cells were deleted, I couldn't find a way to save the range that was chosen before a new cell became active. I think I walked around the block to get next door, but it works well.
Thanks for the input!