hi,
not sure but i think you are trying to show a form.
if so, try something more like this.

Load frmCalendar
frmCalendar.Show 0

the name of my form is frmCalendar

regards
FSt2


"Carrie" wrote:

my macro shows
Sub Insert()
'
' Insert Macro
' insert new cards
'
' Keyboard Shortcut: Ctrl+a
'
ActiveSheet.ShowDataForm
End Sub


when i go to run it...it says run time error 1004.

how do i correct this??

thanks!