macro...additional info
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! |
macro...additional info
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! |
macro...additional info
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 |
All times are GMT +1. The time now is 04:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com