disable vs enable macros

[Guest]

Could someone let me know what effects a document would have if I selected disable macros upon opening vs enable macros. I understand which the choices are but I'm not sure of the limits...
hope that makes sense..
Thanks
Kim

 

[Gord Dibben]

Kim

Macros are designed to automate tasks within Excel, either through event code
or user-activation via button, shortcut or other means.

If you disable macros on opening the workbook, you will lose that automated
functionality.

For example, a workbook_open macro could be coded to pull in data from an
external source when the workbook is opened. You would not get this data.

Depending upon coding, you may not even be able to access any worksheets or
existing data.

Gord Dibben Excel MVP

 

[Guest]

Thank you thats exactly what I was looking for!