Link to home
Start Free TrialLog in
Avatar of John Carney
John CarneyFlag for United States of America

asked on

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
Avatar of John Carney
John Carney
Flag of United States of America image

ASKER

I forgot to add that some of the macros are initiating when an external workbook is the active workbook.
ASKER CERTIFIED SOLUTION
Avatar of Rartemass
Rartemass
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That's kind of what I figured. Thanks, at least, for confirming my suspicions!

- John
No worries. Hope you get something sorted without too much effort.