What would be the best way to replace a formula on a workbook that has been distributed to aprox. 1000 users without resending the sheet? I would like to send some sort of "patch" to the users which would replace the formula in the sheet without changing the data throughout the rest of the workbook.
The average end user is technically challenged.
Would it be a worksheet when opened prompted the user to open the other WB (the one that needs corrected) which would then navigate to the WS that holds the formula, turns off the protection, replaces the old formula in the cell, turns on protection, then saves the WB?
thanks
frank
The average end user is technically challenged.
Would it be a worksheet when opened prompted the user to open the other WB (the one that needs corrected) which would then navigate to the WS that holds the formula, turns off the protection, replaces the old formula in the cell, turns on protection, then saves the WB?
thanks
frank