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??
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
I always use theOriginally Posted by Gaz_Carr
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."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks