command button only to show on certain weekday

[JamesT1]

hi guys

This one has me stumped,,, i thought it would be a small macro..

when a userform opens,,, I would like a command button/ text box only to show on a certain day..... I thought the code below would show a command button on a friday... cant get it to work.. am I going down the right road..

I also tried referencing a cell witht eh weekday in it,,, same result... many thanks

Private Sub UserForm_Open()

If (Weekday(Now())) = 6 Then
cmd1.Visible = True
End Sub