Hi
I created a Module called "Test" ie sub Test( ). It is a very simple macro
that sorts a few tables in a single sheet

I added the same code to a Workbook open function ie Private Sub
Workbook_Open( ) which works fine

However I want it so that I update the code in one place ie sub Test ( ), I
simply point to this from whereever I want - this way I only update once and
don't need to ensure the code is always the same.

Background is I want to force the sort in many instances eg manually, when I
open the workbook, when I activate a new sheet etc

thanks in advance




--
Kevin