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

Cut out your Workbook_Open procedure into a Module. Call to the name of the
Sub from your Workbook_Open function and from your commandButton function.




"Anthony" wrote in message
...
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

Hi Anthony,

In addition to Eddie's solution., as you have declared the Workbook_Open sub
public, you can call it from a button by prefixing the sub name with the
module name, e.g.:

Private Sub CommandButton1_Click()
Call ThisWorkbook.Workbook_Open
End Sub

---
Regards,
Norman



"Anthony" wrote in message
...
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