vba code for len text not working when sheet is not active

How to make the code below works when the macro is triggered on another sheet in the same workbook

The sheet tab is workings but do not highlight text when more than 8 digits or less than 7 digits .
When triggered on active sheet without those in red , it works , but triggered on another sheet shows no response at all when those in red is inserted

Please Login or Register  to view this content.

No , What I want to do is to trigger the macro from another sheet in same workbook

Suppose I have my macro button on sheet tab call trigger all, the above macro should look on sheet "workings" and check for + 8digits and less -7 digits and highlight as per specifications

Thank you