make a new wbook with an internal macro… (2000)

Topic

New Reply

… from a macro i make a new wbook and send this via e-mail. All is ok! My problem is when a make a new file is possible to write in this new file a macro associated in a botton and send this?

Reply | Quote

Replies

Hi Sal,

Here is a snippet of code to add a command button to an active worksheet:

ActiveSheet.OLEObjects.Add(ClassType:=”Forms.CommandButton.1″, Link:=False _
, DisplayAsIcon:=False, Left:=38.25, Top:=14.25, Width:=139.5, Height _
:=43.5).Select

I hope it helps get you started.

Regards,

Andy S.

Reply | Quote

Hi Sal,

Here is a snippet of code to add a command button to an active worksheet:

ActiveSheet.OLEObjects.Add(ClassType:=”Forms.CommandButton.1″, Link:=False _
, DisplayAsIcon:=False, Left:=38.25, Top:=14.25, Width:=139.5, Height _
:=43.5).Select

I hope it helps get you started.

Regards,

Andy S.

Reply | Quote