Calendar Control Problems

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??

im also getting runtime error 424 object required and it highlights the row

FrmCalendar.Show

Originally Posted by Gaz_Carr

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??

I always use the
tools
macro
record a new macro
I will then select a cell and then stop the recording
this does one thing . It creates the the module in vba I can then go in to the module and delete the little bit of code it created. you now have a macro sub routine that is empty.

(ie)
Sub test()
'
' test Macro
' Macro recorded 2006/10/06 by Alien
'

'
Range("G12").Select
End Sub

leaving this as your empty macro

now I am guessing you have a form for your calender
in the empty macro shell put this code


Sub test()
load FrmCalendar
FrmCalendar.Show
End Sub

now your macro will load your form and show it on your excel sheet.

I know this is the long way around to answering your question .. but it is a way to create new macros if your not sure what the code should look like.
anyway it works for me I hope it will be of help to you.

"There are 10 kinds of people in the world, those that understand binary, and those that don't."