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 |
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 |
All times are GMT +1. The time now is 08:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com