Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    ... 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?

  2. #2
    New Lounger
    Join Date
    Apr 2004
    Location
    Lancaster, Pennsylvania
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: make a new wbook with an internal macro... (2000)

    Hi Sal,

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

    ActiveSheet.OLEObjects.Add(ClassType:="Forms.Comma ndButton.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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •