Activate macro is running well independently but not in this workbook automatically

Hello friends,
The activate macro is working fine independently but not in a this workbook code automatically. I'm not getting any error but the macro is not running. I want to focus on 'search' sheet cell 'c4' after running other macros. No matter on which sheet I was last time at the time of closing the file. After opening the file all the other macros should run first and at last the 'activate' macro should run and focus on 'search' sheet cell 'c4' automatically. This is my requirement.

Please help me to solve this problem.

Thanking you in anticipation.

Mukesh