Running Worksheet_Activate macro from another macro

[dhregan]

In a worksheet titled "Monthly", I have written a Worksheet_Activate macro which reviews the value of cell A5 to determine whether to lock (protect the contents) of cell B5. When I click on the Monthly tab, I have confirmed that the Worksheet_Activate macro operates as expected.

If I change to value in cell A5, I have the need to run a different macro called "Generate Results". How can I ensure that Worksheet_Activate within the Monthly tab is run each time I run the Generate Results macro?

 

[machopicho]

...mmmmmm
you should call "Generate Results" into Monthly:

Sub Monthly()
...
...
...
call Generate Results
...
...
Ens Sub