+ Reply to Thread
Results 1 to 4 of 4

Full Screen With Out Tool Bars

  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Full Screen With Out Tool Bars

    Hi, I'm using this script below too make excel full screen at workbook open event. Which works for several worksheets. However at some point

    (It appears to show up after I have used another script to activate another window that the user needs to copy information from and once the user returns to excel by clicking the excel spreadsheet in the windows task bar is when this gray bar appears at the top of the spreadsheet)

    if I double click on this gray bar at the top of the excel window a customize window pops up. I like to hide this bar as well.

    Any Idea's?

    Thanks as always, Mike

    Please Login or Register  to view this content.
    Last edited by realniceguy5000; 11-02-2011 at 11:27 AM. Reason: Change Title

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Full Screen With Out Tool Bars

    If you put this into the workbook module ?

    Please Login or Register  to view this content.



  3. #3
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Full Screen With Out Tool Bars

    I tried that as well but the screen appears to be at full screen already,Plus when the window is click the event does not appear to fire for some reason.

    I did step through the code to make the window full screen but that gray bar is still there, there is no tool bars visible on the bar just gray blank bar. is there some name for this tool bar menu? maybe I can hide that by name?

    Thank You, Mike

  4. #4
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Full Screen With Out Tool Bars

    Ok, I found an answer here:In case someone has the same problem here is the link.

    http://visualbasic.ittoolbox.com/gro...n-excel-367016



    Not sure why it works but it does.

    Apparently after one uses screen updating this issue appears. Here is the code to fix according to the link:

    When you turn screen updating off use this:

    Please Login or Register  to view this content.
    When you turn it on use this:

    Please Login or Register  to view this content.
    Worked for my problem anyway, Thank You Mike

+ 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