I have 80+ templates that are use in my department. Each one has cells containing formulas. How can I protect certain cells w formulas from being deleted (deleted by user and by command button). I cannot use the protect sheet method - it will need to be vba and the vba needs to work on it own (no command buttons). One of the formulas is linked to two modules and the protect sheet method throws a error in the formula. This formula and vba attached to it make a barcode (shape) appear for each order number entered. The user keep deleting the formula in error and I'm having to go round and put back in each time. I need a way they cannot delete the formula and the formula still work to make barcode (which is a shape).
Thank you so much.
Thank you so much.