+ Reply to Thread
Results 1 to 9 of 9

code for hiding taskbar

  1. 10-26-2010, 04:12 AM #1
    ditisFloris
    ditisFloris is offline
    Registered User
    Join Date
    10-19-2010
    Location
    netherlands
    MS-Off Ver
    Excel 2007, 2010 (Win 7 x64)
    Posts
    10

    Smile code for hiding taskbar

    Hey'all
    This forum has come very handy to me, but now I've found a code that doesn't work for me.

    I'm looking for a macro that can toggle the task bar from showing. With the purpose I can run the excel program in full-screen.

    code i found on this forum:
    Please Login or Register  to view this content.
    I have windows 7 and excel 2007. For me, this code make's the task bar invisible, but the start button is still visible. and i can't run excel full screen because the space of the task bar is still token.

    (I added a print screen for you to see how the macro works for me)

    Can anybody help me with this?

    Thanks in advance
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-26-2010, 04:33 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: code for hiding taskbar

    Why not just use display full screen
    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
    Reply With QuoteRegister To Reply
  3. 10-26-2010, 04:38 AM #3
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: code for hiding taskbar

    There's an example in this earlier post
    Reply With QuoteRegister To Reply
  4. 10-26-2010, 04:38 AM #4
    ditisFloris
    ditisFloris is offline
    Registered User
    Join Date
    10-19-2010
    Location
    netherlands
    MS-Off Ver
    Excel 2007, 2010 (Win 7 x64)
    Posts
    10

    Re: code for hiding taskbar

    full screen won't go really full. you can still see the task bar.
    Reply With QuoteRegister To Reply
  5. 10-26-2010, 05:01 AM #5
    ditisFloris
    ditisFloris is offline
    Registered User
    Join Date
    10-19-2010
    Location
    netherlands
    MS-Off Ver
    Excel 2007, 2010 (Win 7 x64)
    Posts
    10

    Re: code for hiding taskbar

    thanks for the quick response roy.

    I can certainly use some part of that code. but it still won't remove the system tray..
    Reply With QuoteRegister To Reply
  6. 01-20-2011, 06:09 PM #6
    Paradigm
    Paradigm is offline
    Registered User
    Join Date
    01-20-2011
    Location
    Northampton
    MS-Off Ver
    Excel 2010
    Posts
    3

    Post Re: code for hiding taskbar

    I use Windows 7 too. So far I have not found an elegant method of hiding the Taskbar + the Start Button in this OS (and believe me I have tried). I even used VS Spy utility to try to 'Switch off' the Button according to Class & Caption but to no avail.

    So, I use the following Code to toggle the Taskbar Status. By forcing Excel FullScreen it will then occupy the entire Desktop Window.
    Please Login or Register  to view this content.
    The Error Handler Code is Optional.

    I have written a FullScreen Add-In at:
    http://www.kubiszyn.co.uk

    I am also working on a Free 2003 Add-In which will run along the same lines by toggling the Taskbar Status. When this is finalised I will Post up some Code for re-styling the Excel App + Hiding the Taskbar. Mark Kubiszyn.
    Last edited by Leith Ross; 01-20-2011 at 10:18 PM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  7. 01-20-2011, 10:09 PM #7
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: code for hiding taskbar

    Hello ditisFloris,

    Copy this code into a separate VBA module in your workbook. Call the macro ShowFullScreen in your code. Be sure to call ShowNormalScreen before you close the workbook.
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 01-20-2011 at 10:17 PM.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  8. 01-20-2011, 11:11 PM #8
    Armando Montes
    Armando Montes is offline
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Mexico
    Posts
    200

    Re: code for hiding taskbar

    Not sure if these will help:
    http://www.xp-tips.com/auto-hide-taskbar.html
    http://www.aeonity.com/frost/removin...p-taskbar-hack
    http://www.windowsnetworking.com/kba...hetaskbar.html
    Reply With QuoteRegister To Reply
  9. 01-21-2011, 07:50 AM #9
    ditisFloris
    ditisFloris is offline
    Registered User
    Join Date
    10-19-2010
    Location
    netherlands
    MS-Off Ver
    Excel 2007, 2010 (Win 7 x64)
    Posts
    10

    Re: code for hiding taskbar

    Great job! Thank you my friend
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1