Difference between Workbook Macros and Global Macros?

[Peter Me]

Hey,

I was just wondering if someone could please tell me the difference between Workbook Macros and Global Macros?

I'm trying to figure it out by searching on search engines, but I can't seem to understand.

Thanks in advance

 

[Tom Urtis]

Never heard of a "global macro" so maybe you are referring to:
• a variable declared as Public
• an add-in
• a macro in your Personal Macro Workbook

Or maybe something else...try explaining where you saw this term and under what context.

 

[Ruddles]

If you want to use any of the worksheet event handlers - like the one which is triggered by worksheet changes - they must be in the worksheet code modules (Sheet1, Sheet2, etc), otherwise they won't work.

If you want to use any of the workbook event handlers - like the one which is triggered by when the workbook opens - they must be in the workbook code module (ThisWorkbook), otherwise they won't work.

A list of event handlers appropriate to the module you're in is available via the drop-down list at the top of the code window.

Although you can also put other code in those modules, I tend to keep code which isn't even-handling code in standard or general code modules. Also any general-purpose code which is called from other modules, and also user-defined functions.

 

[Peter Me]

Never heard of a "global macro" so maybe you are referring to:
• a variable declared as Public
• an add-in
• a macro in your Personal Macro Workbook

Or maybe something else...try explaining where you saw this term and under what context.

This is what I saw Tom:

Use the following Automation techniques
- Workbook Macros
- Global and global macros (for printing or formatting)

 

[Tom Urtis]

Still don't recognize it but how about just explaining what you want to do, or what task you are faced with, and that kind of detail will enable someone to assist better.

 

[Peter Me]

I've got to use and compare two automation techniques, which are: Workbook Macros and Global and global macros (for printing or formatting). I need to compare the difference between them, and explain what they are used for and why I would use them for a particular task.

 

[Tom Urtis]

Well, we've come full circle. If this is some kind of work or school assignment, I'd get clarification from whoever asked you to do this as to what exactly they are expecting as a result for example, so you can submit the kind of result that is expected. What you wrote could mean a number of possibilities, which means the odds of guessing wrong is pretty high with whatever possibility you choose.

 

[Peter Me]

Well, we've come full circle. If this is some kind of work or school assignment, I'd get clarification from whoever asked you to do this as to what exactly they are expecting as a result for example, so you can submit the kind of result that is expected. What you wrote could mean a number of possibilities, which means the odds of guessing wrong is pretty high with whatever possibility you choose.

Okay thanks for your help anyway Tom.