Control automatic runs of macros

Hi,

There is a following code:

MACRO1

Please Login or Register  to view this content.

And the file "FIRST\GRAND EVALUATIONS.xlsm" has got the following code:

MACRO2

Private Sub Workbook_Open()

Please Login or Register  to view this content.

Here, whenever a file "FIRST\GRAND EVALUATIONS.xlsm" is opened, it runs a macro2 . But I would like to control the running of that macro, so that it runs only when it is told to do so.

Please provide me with some solutions to control that macro2 from regular RUNS.

Thanks