I have produced some code, which works perfectly and does exactly what I
want. The code uses the Workbook_open function and the main calls to
other procedures runs from there.

The issue I have, is I need to trigger the workbook_open function from
an on screen button and I just cant work out how to do this, as it is
saying sub / function not defined even though I have set the
Workbook_open function to public.

any help appreciated

Anthony Taylor