View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default question regarding Visible Propery

Hi,

See code below. When I open workbook, click the assigned button userform1
appears & although my username is not dresses frame4 and commandbutton2 are
shown. When I close userform1 and then reopen userform1 through the
aforementioned button frame4 and commandbutton2 are hidden (like it should).
Can anyone help me with this?



Sub Uncancel_sim()

UserForm1.Show
If Application.UserName = "dresses" Then
UserForm1.CommandButton2.Visible = False
UserForm1.Frame4.Visible = False
Else
UserForm1.CommandButton2.Visible = True
UserForm1.Frame4.Visible = True
End If

End Sub

Regards,

Basta1980