? activate a commandbutton in code ?

does anybody know how to activate a commandbutton in a macro?

(there is no way around me having to do this... i need to batch a very poorly organized workbook, and i have to go through a commandbutton to do so)

to activate the commandbutton normally you just "click" it with the mouse. but i cant figure out how to do it in a macro. i want to automate this workbook so i can run this program multiple times. ive tried dozens of different lines and none work. ive also tried recording a macro to show me the correct code but the recorder stops when you try to do this.

!!! PLEASE - SOMEONE HELP !!!

Change the click event from Private to public, then you just call the event
in your code.

Private Sub Commandbutton1_Click()
changed to
Public Sub Commandbutton1_Click()

then call it with

Sheet1!CommandButton1_Click'

where Sheet1 is the code name of the sheet containing the code.

--
Regards,
Tom Ogilvy

"tad_wegner" <[email protected]> wrote
in message news:[email protected]...
>
> does anybody know how to activate a commandbutton in a macro?
>
> (there is no way around me having to do this... i need to batch a very
> poorly organized workbook, and i have to go through a commandbutton to
> do so)
>
> to activate the commandbutton normally you just "click" it with the
> mouse. but i cant figure out how to do it in a macro. i want to
> automate this workbook so i can run this program multiple times. ive
> tried dozens of different lines and none work. ive also tried recording
> a macro to show me the correct code but the recorder stops when you try
> to do this.
>
> !!! PLEASE - SOMEONE HELP !!!
>
>
> --
> tad_wegner
> ------------------------------------------------------------------------
> tad_wegner's Profile:
http://www.excelforum.com/member.php...o&userid=27770
> View this thread: http://www.excelforum.com/showthread...hreadid=474762
>