how can we invoke private events from outside.

[laks143]

I am trying to call private events .

sheet.Worksheets(1).CommandButton1_Click

this macro tool is placed in share ...and no one can edit this.the events in the tool are private ..i am not able to call.how can i call this events without changing them from private to public.

thanks in Advance !!!

 

[markdmac]

http://support.microsoft.com/kb/555375

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.