Setting default module in VBA

[Jaymond Flurrie]

Is there any way to set a default module in VBA? I have a workbook with two modules, one of them having code that I use next to never and one of them has code that I use several times a day. Everytime I open this workbook and press Alt+F11, the module I rarely use is opened (i.e. is the default module). How can I change this?

 

[wigi]

I am NOT sure, but I *think* it defaults to the last module created.
Can you verify this/test this and if it is true, you could delete the modules after exporting the code and import them again.

 

[S.H.A.D.O.]

What I normally do is just re-arrange the code in the Modules so the one I use most is in the last Module and therefore opens up when I press Alt+F11. Just insert a new Module and cut and paste the code in there and then delete the empty Module that is left.

BTW, this does not seem to work if you have say 10 or Modules because of the way they are sorted!

The other way of course is to add a button and run the Macro from there.

I hope this helps!

 

[Jaymond Flurrie]

What I normally do is just re-arrange the code in the Modules so the one I use most is in the last Module and therefore opens up when I press Alt+F11. Just insert a new Module and cut and paste the code in there and then delete the empty Module that is left.

I hope this helps!

Yeah, I thought this might be one solution and unless someone comes up with some "check the box in..." etc. answer, this is what I will do.

Thanks!

 

[S.H.A.D.O.]

You're welcome!

The other way of course is to add a button and run the Macro from there.

Thanks for the feedback.

 

[Jaymond Flurrie]

You're welcome!

The other way of course is to add a button and run the Macro from there.

Thanks for the feedback.

Or to make a shortcut key. The button is that kind of limited solution that (unless you mean a button in the ribbon), you have to go to some certain sheet to use it.