excel - Run Worksheet Modules on Save -

i have macro running within 4 worksheets highlights cell rows within range (the ranges differ each worksheet) keep worksheet looking clean , not leave highlighting has built in line tells clear highlighting when click cell a6 in each of worksheets macro contained. issue getting others use worksheet follow method, trying see if there way use workbook_beforesave workbook function clear highlighting on worksheets when file saved.

is there way iterate "clear formatting" sub exists in each worksheet workbook module? clearing code in worksheet modules follows (but cannot seem function within workbook module):

dim binrange boolean static rold range  if not binrange set rold = nothing exit sub end if 

create sub code. this.

private sub runmycode()     dim binrange boolean     static rold range      if not binrange         set rold = nothing         exit sub     end if end sub  private sub workbook_beforeclose(cancel boolean)     'call before workbook closed     runmycode end sub