Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting Not Immediately Refreshing after Macro Exec
I have a worksheet that includes conditional formatting and a button that
executes a macro to clear and update a few of the cells. These cells are not the ones with the conditional formatting. My problem/issue is that when I execute the macro the conditional formatted cells are reset to their pre-conditional format condition. Immediately afterwards I can enter data into any unrelated cell and the conditional formatting takes effect. Pressing F9 (recalculate) also would make the conditional formatting effective. Ive tried adding the 'application.calculate' code to the end of the macro but it has no impact. What am I doing, or not doing to cause the conditional formatting to act this way? Thanks - Pat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Conditional formatting not refreshing as it did in 2003 | Excel Discussion (Misc queries) | |||
Conditional formatting - Not refreshing | Excel Discussion (Misc queries) | |||
How to exec a commandbar button while cell in edit mode | Excel Programming | |||
How do I keep my own formatting for a pivot-chart on refreshing | New Users to Excel |