... im really starting to like this forum....

I worked this out, came back to the forum, and the answer was here..
Using Tom's suggestion.

----
I put all my code into "Module1". all the "Const" delcarations, all the
code from "Workbook_open" and the code from sheet1 for the button
"Testing_Button_Click".

In the call in "ThisWorkBook" "Workbook_Open", i put one line to call
the subroutine i copied the code into.... "Test_Button" (which is now
stored in the module).

So in summary, all code, and variables are in one module, its all
visible and can be called from anywhere.

....Many Thanks again !!... you cant see the huge smile on my face....
::))