Ive created a calendar in another sheet within the same workbook and all is fine untill I set up the module to load the macro from excel.The code im using is

Sub OpenCalendar()
FrmCalendar.Show
End Sub

Any ideas??