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