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!

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!

Check your earlier post.

It's usually much better to continue the conversation in the same thread.

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!

--

Dave Peterson