Macro deletion

  • Thread starter Thread starter Patricia D
  • Start date Start date
P

Patricia D

I am brand new at macros. I created one for practice, it worked, then I
deleted it at excel tools>macro>delete. 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
 
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
 
Back
Top