+ Reply to Thread
Results 1 to 5 of 5

Can't unhide a hidden excel application

  1. #1
    Registered User
    Join Date
    01-14-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    29

    Talking Can't unhide a hidden excel application

    Already read some threads about how to hide and unhide an excel application.
    I was able to hide my excel application, but, somehow I'm not ale to unhide it when I close my Form:

    Please Login or Register  to view this content.
    I put the following code in my QueryClose sub form:

    Please Login or Register  to view this content.
    I dont know why, but when I close the form, It doesnt go to the QueryClose sub.
    I rename the form to "Form_Inicio" and already substitute the code to:

    Please Login or Register  to view this content.
    The problem stays the same.
    Any help please???
    Last edited by mjcordeiro; 01-04-2010 at 04:13 PM.

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

    Re: Can't unhide a hidden excel application

    Your last code with the changed name will not work.

    Use Ctrl->Alt->Delete to close the hidden applicationthen try using the Terminate event
    Please Login or Register  to view this content.
    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
    01-14-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Can't unhide a hidden excel application

    Thank you very much.
    I try it and it's working now.
    But I have to take out the "Option Explicit" because I don't have all the variables declared.
    Meanwhile, It's convinient to use this statment? Why It's used?

    Thank you once again,

    MC

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

    Re: Can't unhide a hidden excel application

    You should declare all your variables.

    You need to add this to use QueryClose
    Please Login or Register  to view this content.
    Last edited by royUK; 01-04-2010 at 03:56 PM.

  5. #5
    Registered User
    Join Date
    01-14-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Can't unhide a hidden excel application

    Hello royUK,

    Thank you very much for your help.

    Best regards,
    Mário

+ 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