macro...additional info

[Carrie]

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!

 

[FSt1]

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

 

[Dave Peterson]

Check your earlier post.

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