vba to update linked pictures when a cell value is TRUE

[cjcass]

Hi,
I have a wksht with 20 pictures in it. Each picture is linked to a range of cells in other wkshts via named ranges. The pictures all update when the cell value in S4 contains 'TRUE' and when the cell value is 'FALSE' the pictures don't update. When I manually type 'TRUE' into S4 or select 'TRUE' from a dropdown list the pictures update, however when I run the following macro the pictures won't update. I'm guessing there is something wrong with the code? Any help much appreciated.

Sheet88.Select
    
    Range("S4").Select
    ActiveCell.FormulaR1C1 = "TRUE"
    Range("S5").Select
    
    Range("S4").Select
    ActiveCell.FormulaR1C1 = "FALSE"
    Range("S5").Select

 

[cjcass]

anyone have any thoughts on this?
thanks

 

[cjcass]

ok, have found a massively simple solution, put the following code between the two actions...

DoEvents