View Full Version : Set Formula and Notify if changed
jenroyce
04-11-2011, 06:39 PM
Hi,
Would like to ask if there's a way to set specific formulas to an excel workbook and when the set formula is changed, an error will pop up or its visible?
Is this Circular Reference?
shrivallabha
04-11-2011, 09:32 PM
Instead of popping message / alert, why don't you protect these cells? Is there any reason?
jenroyce
04-11-2011, 10:59 PM
Actually i already have a plan of proctecting them once im done with the file, but since this will be used for a long time and will be used as basis for incentives/bonus, i would like to make sure of the following:
1. That the formula references will not change, or if it does change, i can be notified or show an error that the formula reference is different than previous and approve the change.
2. I myself, can track if I'm changing the formula and if Im using the correct reference.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.