I have a workbook with 10 sheets and currently use the formula

sheets("sheet2").select
Range ("a1").select
Activecell.formularR1c1= "true"

and repeat this for sheet3,4,5 and so on
Note not all the values are identical some are true and some false

Because the VBA sub has to then jump to every sheet and then enter the
value it creates a flashing effect that irritates the hell out of me

Is there a code where it will make those changes in other sheets
without activating those sheets first

PLEASE Help
Thanks
Herman