Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger macro on value only
I have a user form with a calculated amount column that contains
formulas. My users inadvertantly keep deleting these cells. If I lock them and enable protection, they don't let the program change calculated values. My idea was: To move these cells out of site, Trigger an ON CHANGE EVENT to run a macro which will copy and PASTE VALUES ONLY back to the form. Problem is that the ON CHANGE EVENT only triggers on changes in the cells formula, not in its calculated displayed value. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger macro on value only
In your program, unprotect the sheet, change values, the protect it again.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... I have a user form with a calculated amount column that contains formulas. My users inadvertantly keep deleting these cells. If I lock them and enable protection, they don't let the program change calculated values. My idea was: To move these cells out of site, Trigger an ON CHANGE EVENT to run a macro which will copy and PASTE VALUES ONLY back to the form. Problem is that the ON CHANGE EVENT only triggers on changes in the cells formula, not in its calculated displayed value. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger macro on value only
Sheet is unprotected
Problem is that the ON CHANGE EVENT only triggers on changes in the cells formula, not in its calculated displayed value. Bob Phillips wrote: In your program, unprotect the sheet, change values, the protect it again. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... I have a user form with a calculated amount column that contains formulas. My users inadvertantly keep deleting these cells. If I lock them and enable protection, they don't let the program change calculated values. My idea was: To move these cells out of site, Trigger an ON CHANGE EVENT to run a macro which will copy and PASTE VALUES ONLY back to the form. Problem is that the ON CHANGE EVENT only triggers on changes in the cells formula, not in its calculated displayed value. Any ideas? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger macro on value only
No I am saying forget your alternative, lock the cells and manage it as I
suggested. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ups.com... Sheet is unprotected Problem is that the ON CHANGE EVENT only triggers on changes in the cells formula, not in its calculated displayed value. Bob Phillips wrote: In your program, unprotect the sheet, change values, the protect it again. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... I have a user form with a calculated amount column that contains formulas. My users inadvertantly keep deleting these cells. If I lock them and enable protection, they don't let the program change calculated values. My idea was: To move these cells out of site, Trigger an ON CHANGE EVENT to run a macro which will copy and PASTE VALUES ONLY back to the form. Problem is that the ON CHANGE EVENT only triggers on changes in the cells formula, not in its calculated displayed value. Any ideas? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger macro on value only
Thanks
Sometimes I can't see the obvious. Bob Phillips wrote: No I am saying forget your alternative, lock the cells and manage it as I suggested. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ups.com... Sheet is unprotected Problem is that the ON CHANGE EVENT only triggers on changes in the cells formula, not in its calculated displayed value. Bob Phillips wrote: In your program, unprotect the sheet, change values, the protect it again. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... I have a user form with a calculated amount column that contains formulas. My users inadvertantly keep deleting these cells. If I lock them and enable protection, they don't let the program change calculated values. My idea was: To move these cells out of site, Trigger an ON CHANGE EVENT to run a macro which will copy and PASTE VALUES ONLY back to the form. Problem is that the ON CHANGE EVENT only triggers on changes in the cells formula, not in its calculated displayed value. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro trigger | Excel Discussion (Misc queries) | |||
Another way to trigger a macro? | Excel Programming | |||
Trigger a Macro in MS Access from an Excel Macro? | Excel Programming | |||
Macro trigger? | Excel Programming | |||
Macro trigger? | Excel Programming |