VBA Macros

[WaterSprite]

Ok. Time for an RSQ.(Really Stupid Question)

When I start a project, I usually prepare several blank macros ahead of time, using tools, macro, record new macro, ok on the box, then stop button. I do this several times so the Macros are in the same module.

Is there a faster way, or will VBA prepare blank macros for me?

Also, on one of my computers, I have "lost" the Stop button that pops up on the spreadsheet. How do I get it back.

 

[AnotherHiggins]

In the VBE (VB Editor), Right Click anywhere in the project where you want a module. Select Insert > Module.

This can be done via a macro as well, but it's pretty darned easy to add them on the fly.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[fumei]

There is a difference between blank macros (Subs), and empty Modules. A module contains Subs (as well as Functions, Constants etc.).

If by "blank macros" you mean:

Sub Blah_1()

End Sub


Sub  Yadda_Whatever()

End Sub

, which is essentially what you are doing whyen you record a macro, do no actions, and then Stop it, then you can simply just write a bunch like the above. It can also be done via code, but what exactly is the point of you doing this anyway????

faq219-2884

Gerry
My paintings and sculpture