+ Reply to Thread
Results 1 to 9 of 9

Closing macro window

  1. #1
    Registered User
    Join Date
    09-05-2010
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2007
    Posts
    18

    Closing macro window

    Hi, I am new to VBA and am trying to create macro's to create and complete invoices from data I enter on a separate worksheet. The beginning of my programming is going well as I have a book on VBA and the knowledge gained from the web.
    The question I would like to ask, as I can't find reference or an answer to my problem, is how do you stop the VBA macro listing window popping up in excel after running the macros from an assigned button.
    Last edited by DaveLearner; 09-05-2010 at 11:31 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Closin macro window

    I'm puzzled why you actually need VBA to do this
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-05-2010
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2007
    Posts
    18

    Post Re: Closin macro window

    The macro's I have produced so far copies a template, filled with data, to produce a new worksheet. This is then renamed with a cell reference and the template reference number is incremented by 1 for the next entries. This is all controlled from a macro enabled button. When I test this by clicking on the button all works fine but the macro code window appears. I was looking for some way to stop this happening so that the form produced looked and operated more professionally.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Closin macro window

    It shouldn't happen. Try attaching the workbook so we can see.

  5. #5
    Registered User
    Join Date
    09-05-2010
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Closing macro window

    Here is the workbook so far. When I click on "Enter data" the macro's work fine.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Closing macro window

    Sorry, no attachment

  7. #7
    Registered User
    Join Date
    09-05-2010
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Closing macro window

    Hopefully file attached this time. I had tried to upload a template.
    Attached Files Attached Files

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,817

    Re: Closing macro window

    Try this:

    Please Login or Register  to view this content.

    Regards

  9. #9
    Registered User
    Join Date
    09-05-2010
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Closing macro window

    Thanks THSchucks. That has solved my problems for the time being. I'm bound to come across a few more as I develop my program. I'll will post any future problems for you wonderful people to steer me in the right direction. Again thanks

+ 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