Stop control redrawing?

Is there any way to temporarily stop a Spreadsheet Control from redrawing itself whenever I alter the cell contents / formatting? I want to stop it from doing so until the entire table is ready, and then have it refresh just once.

I had been hiding the control (setting Visible = False) which did the job until it started going wrong - sometimes after hiding the control it won't display properly afterwards. :(

try:

VB Code:

application.screenupdating = false

this will disable the screen update..

then when you want to update the screen set it to true