Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Temporarily hiding Taskbar (xp)

    In xp the Taskbar can be temporarily hidden: Rt click START| Properties | Taskbar Tab | Unselect: Keep the taskbar on top of other windows.

    Is there some VBA code that I can use to accomplish this while my app is running, then turn it back on as the user leaves the app?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Temporarily hiding Taskbar (xp)

    I imagine you would have to use SHELL to call windows XP and then use SENDKEYS to send the keystrokes to windows app. Though I am fuzzy on details and can't test since I don't have XP at work.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Temporarily hiding Taskbar (xp)

    Steve

    Actually I want this to be backward compatible and not limited to xp. Can you give me the specifics for the SHELL procedure as well as SENDKEY
    thanks

    Paul

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Temporarily hiding Taskbar (xp)

    You can goto VB and look under Sendkeys for an example (using the calculator).

    Calling windows is not really an excel question and is outside my expertise. You might want to post on the general windows board or the VB board. I can show you how if you tell how to CALL the windows program (path and filename) and what keys to send (how do you do it with the keyboard) The shell program opens the program and the sendkeys sends the keys. You are actually having excel just "sendkeys" to the other program just like you are typing them into the keyboard.

    Steve

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

    Re: Temporarily hiding Taskbar (xp)

    Question has been reposted in VB/VBA in <post#=297236>post 297236</post#>. Replies over there, please, to avoid confusion and duplication. I am locking this thread.

Posting Permissions

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