Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding Worksheet while VBA App runs (2003)

    I have a project that I have been working on this week and it is done except for some minor tweaks. It is a user survey that captures results into a worksheet. I start it with a button on the worksheet, and the worksheet is visible while the VBA App is running. So here are my questions:

    1) How can I hide Excel while the VBA App runs?
    2) Can I start the app when the excel file is opened?
    2a) If the VBA app starts when this file is opened, how do I ever get at the worksheet?

    Thanks,

    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding Worksheet while VBA App runs (2003)

    You can set Application.Visible = False in the UserForm_Initialize procedure, and if you wish Application.Visible = True in the On Click procedure of the Close button.

    You can call OpenSurveyForm in the Workbook_Open event procedure (in ThisWorkbook).
    If you hold down Shift while opening the workbook, the Workbook_Open code will not run.

    See attached version.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding Worksheet while VBA App runs (2003)

    N.B. the caption of the first command button on the userform should be Submit instead of Sumbit. <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

  4. #4
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Worksheet while VBA App runs (2003)

    Jeez, thanks for the spelling catch ;-) and for the tip.

    Andy

Posting Permissions

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