Screen Updating not working

[VBAnewguy]

I have "screen updating" currently turned off on my Excel application. It does not seem to be working, when I load the spreadsheet it still flickers as all of the objects are loaded onto the page.

Is there another way around this?

 

[bryanbayfield]

if you leave screen updating on is there any difference - ie does it flicker more?

 

[VBAnewguy]

It does not make a difference if it is on or off, it still flickers when the worksheet loads. I will explain a bit more, maybe it has to do with something else.

I have a simple worksheet that has multiple drop down boxes, only certain combo boxes are needed for subsequent selections, so I have a box "shape" that is the same color as the background covering the combo boxes. Then I use the fill color and send-to-back functions to make it dissapear and reapear. When the page loads, the Shape Box seems to be the last object that loads, so you can see all the "covered" combo boxes for a second, until the ShapeBox appears.

Any suggestions.

 

[bryanbayfield]

Instead of that why don't you try playing around with the visible property of the combobox's in the sheet?

eg.

Private Sub ToggleButton1_Change()
If ToggleButton1.Value = False Then
    ComboBox1.Visible = False
    Else: ComboBox1.Visible = True
    End If
End Sub

 

[RobBroekhuis]

Screenupdating doesn't get turned off until your workbook_open event runs - which is most likely AFTER all the on-screen objects are loaded. You can use Bryan's approach by making them all invisible in the workbook_beforeclose event, and making them reappear in the _open event.
Rob