What change should I do to run this macro from standard module?

Hi friends,
The code is working fine in the sheet module but each time I enter any value in sheet 'Information' the macro runs and take a little time to complete which is very annoying for me. It slow downs my speed of work. I want to avoide it and so want to run this macro from standard module. So that whenever I click the macro then only it will run and speed of my work.

Please Login or Register  to view this content.

Please suggest me a amendment to run it from standard module.

Any help will be appreciated.

Thanking you in anticipation.

Please Login or Register  to view this content.

Hard to say what is going on without a sample workbook.

Thank you. Please see the attached workbook.

The code is not working. I have made some changes in it as follows. It works fine but a take a long time to complete. There are about 15 sheets in my original file. So please suggest me a solution to speed up it.

Please Login or Register  to view this content.

Thank you.

Hello mso3,

Perhaps something like the attached sample Workbook.

Regards.