+ Reply to Thread
Results 1 to 3 of 3

Stand Alone program

  1. #1
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Stand Alone program

    Bonjourno!!

    I have created a small Program that utilises the Net Send command.

    However, i wish to get the program to open in a seperate window other than the main excel one.

    Basically i wanted it to be smaller and not affect other sheets that are open.

    i have attached the sheet for you to view and mess about with.

    cheers for reading folks
    Attached Files Attached Files
    Last edited by VBA Noob; 09-18-2007 at 10:26 AM.
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello Macdave_19,

    I would create another userform to do what your main input sheet does. This will give the smaller window you are after. To make it a standalone, save your project as an Add-In. Set the Add-In to open the form when the Add-In is run.

    Sincerely,
    Leith Ross

  3. #3
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Wink Cheers

    Thanks for the help, i've been waiting ages for that one,

    I did think to make it in a userform but i just didn't know about how to use the add in feature. ill give that a try.

    Many thanks

    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1