I am hiding the objects that I want by writing a
function... But -I do not know why- some objects remain appear. And If I minimize and remaximize the page they go. I think this is a typical "Refreshing the screen" problem.
From the helps I've found sth like "object.Repaint" that I think it to be related with the topic. But I couldn't be succesful on applying the method by coding "worksheets(1).repaint".
Could you help me...
Thanks...
This message was edited by secici on 2002-09-23 00:22
This message was edited by secici on 2002-09-23 00:22
Code:
Public Sub HideObject()
Dim SShape As Shape
For Each SShape In pgeSales.Shapes
If Left(SShape.Name, 3) = "cmb" Then
SShape.Visible = False
End If
Next
End Sub
function... But -I do not know why- some objects remain appear. And If I minimize and remaximize the page they go. I think this is a typical "Refreshing the screen" problem.
From the helps I've found sth like "object.Repaint" that I think it to be related with the topic. But I couldn't be succesful on applying the method by coding "worksheets(1).repaint".
Could you help me...
Thanks...
This message was edited by secici on 2002-09-23 00:22
This message was edited by secici on 2002-09-23 00:22