• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Applying a macro to all the macros in a book without having to state it or call it in each macro

In my specific situation at the moment, I want to call this macro at the beginning of every macro. Every macro but 'this' macro itself:  
Sub LogMacro()
Set mLog = [MacroLog].End(xlDown).Offset(1, 0)
Set mLogBtm = mLog.Offset(0, 1).End(xlDown).Offset(0, -1)
mLog = "ΓΌ"
End Sub

Open in new window

Is there a way to do that?

Thanks,
John
0
gabrielPennyback
Asked:
gabrielPennyback
  • 2
  • 2
1 Solution
 
gabrielPennybackAuthor Commented:
I forgot to add that some of the macros are initiating when an external workbook is the active workbook.
0
 
RartemassAuthor, martial arts coach, IT ConsultantCommented:
I don't believe there is a way to do this without using call.

You could however create a user form and have that run the above macro when it loads, then use buttons on the form to run the other macros.
0
 
gabrielPennybackAuthor Commented:
That's kind of what I figured. Thanks, at least, for confirming my suspicions!

- John
0
 
RartemassAuthor, martial arts coach, IT ConsultantCommented:
No worries. Hope you get something sorted without too much effort.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now