calling procedures from worksheet buttons
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
|