|re: "now i want that that macro should be run even when any other user is opening that Excel file"|
If that is the main point of your question, then take a look at the Workbook_Open event.
In the VBA editor, double click the This Workbook module name. Use the Pull down next to General and select Workbook. That should put these lines in the pane:
Private Sub Workbook_Open()
Place your code between these lines, making sure that the code refers to the correct sheets in the workbook and save it. The code should run everytime the workbook is opened.
You may need to add some error handling in case the source data isn't available or something else goes wrong. Since "general users" will be opening the workbook, you may not want them to see - or have to deal with - any errors that occur when the code runs.