Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro deletion
I am brand new at macros. I created one for practice, it worked, then I
deleted it at excel toolsmacrodelete. I went thru the workbook and deleted all the modules, so I don't get the enable/disable warning. But now when I try to create in VBA and hit F5 I get a Macro message box asking for the name of the macro, and of course there is no name to click. Can I get rid of this and get back to square one? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro deletion
You code should be within the Sub/End Sub as below..
Sub MyTestMacro() 'place your code here MsgBox "My new macro" End Sub If this post helps click Yes --------------- Jacob Skaria "Patricia D" wrote: I am brand new at macros. I created one for practice, it worked, then I deleted it at excel toolsmacrodelete. I went thru the workbook and deleted all the modules, so I don't get the enable/disable warning. But now when I try to create in VBA and hit F5 I get a Macro message box asking for the name of the macro, and of course there is no name to click. Can I get rid of this and get back to square one? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I activate a macro of auto deletion with respect to date | New Users to Excel | |||
Row Deletion Question | New Users to Excel | |||
name deletion | Excel Discussion (Misc queries) | |||
Accidental Deletion | Setting up and Configuration of Excel | |||
#REF! after cell deletion | Excel Discussion (Misc queries) |