run macro when sheet opens

[kavanagh]

I have a monthview calender that opens with a created macro button
but I'd like it to open the calender when a worksheet opens without having to use my macro button.
any help would be appreaciated

Thank you in advance. K

heres the code i have



Private Sub CMDCLOSE_Click()
Unload Me
End Sub
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
ActiveCell.Value = MonthView1.Value
Unload Me
End Sub
Private Sub UserForm_Click()
End Sub
Private Sub UserForm_Initialize()
Range("l4").Select
If IsDate(ActiveCell.Value) Then
MonthView1.Value = DateValue(ActiveCell.Value)
Else
MonthView1.Value = Date

End If
End Sub

 

[AlphaFrog]

worksheet opens???
Do you mean when you select or activate the worksheet? If yes...

• Right-click on the worksheet tab that you want this to work on.
• Select View Code from the pop-up menu
• Paste the code below in the VBA edit window.

Private Sub Worksheet_Activate()
    UserForm1.Show
End Sub

UserForm1 is the name of your calendar form.

 

[Maheshp]

In thisworkbook module paste below code

Private Sub Workbook_Open()
Me.Show
End Sub

 

[kavanagh]

Thanks Guys but I just can't seem to get it to work

When I put it in the worksheet tab nothing happens
I get a run time error 424 and object required



When I put it in the workbook Module nothing happens and it gives me a compile error in hidden module.

I need to work on it a bit I'm not that proficient at this

Thank you k

 

[AlphaFrog]

Can you post the code that runs when you click on your macro button?

 

[kavanagh]

Here it is

Sub OPENCALENDER()
FRMCALENDER.Show
End Sub

Thank you for responding

K