+ Reply to Thread
Results 1 to 3 of 3

I want to hide all toolbars all unused cells and open a simple table up

Hybrid View

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Birmingham
    MS-Off Ver
    Excel 2010
    Posts
    3

    I want to hide all toolbars all unused cells and open a simple table up

    Hi guys
    I have a simple 2x30 table in excel I've hidden the cells to the right and beneath now I'd like to hide all the excel toolbars.
    I'd like to click on it so it loads up like a windows exe file just the table and nothing else. Just like the image below loading up with nothing else.
    I just dont know how to hide everything.
    can anyone give me any tips?
    kind regards
    eyespider

    I'm using excel version 14

    excel_table.jpg
    Last edited by eyespider; 03-21-2021 at 08:57 PM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: I want to hide all toolbars all unused cells and open a simple table up

    .

    Here some code that will get you started. You can Google for other examples and additional code to include if necessary.

    NOTE : The following is NOT a complete project. You will need to work with it for your purposes.


    Option Explicit
    
    Sub hide_menu()
    
    With Worksheets("Sheet1")
    
        With ActiveWindow
            .DisplayHorizontalScrollBar = False
            .DisplayVerticalScrollBar = False
        End With
        With Application
            .DisplayFullScreen = True
            .DisplayFormulaBar = False
            .DisplayStatusBar = False
        End With
        With Application
        
            .CommandBars("Full Screen").Visible = False
            .CommandBars("Worksheet Menu Bar").Enabled = False
            .CommandBars("Standard").Visible = False
            .CommandBars("Formatting").Visible = False
        End With
    
    'Hide sheet tabs
        ActiveWindow.DisplayWorkbookTabs = False
        Application.DisplayStatusBar = False
    End With
    End Sub
    
    Sub unhide_menu()
    Application.DisplayAlerts = False
    With Worksheets("Sheet1")
    
        With ActiveWindow
            .DisplayHorizontalScrollBar = True
            .DisplayVerticalScrollBar = True
        End With
        With Application
            .DisplayFullScreen = False
            .DisplayFormulaBar = True
            .DisplayStatusBar = True
        End With
        With Application
            '.CommandBars("Full Screen").Visible = True
            .CommandBars("Worksheet Menu Bar").Enabled = True
            '.CommandBars("Standard").Visible = True
            .CommandBars("Formatting").Visible = True
        End With
    
    'Show sheet tabs
        ActiveWindow.DisplayWorkbookTabs = True
         Application.DisplayStatusBar = True
    End With
    Application.DisplayAlerts = True
    End Sub
    Attached Files Attached Files

  3. #3
    Banned User!
    Join Date
    01-17-2021
    Location
    Omaha, NE
    MS-Off Ver
    office 2016
    Posts
    211

    Re: I want to hide all toolbars all unused cells and open a simple table up

    I think this language has objects in it that are actual toolbars and they represent the different toolbars and ribbon menus in Excel later versions after 2010. You may or might look up on Google the concept of iRibbon. But not sure that might relate 2007 version only. Because ribbon was only in 2007 and after that I think Microsoft start calling it something else but not sure. Don't know what they call it now with the square shape look for each menu.

    If those iRibbon objects cannot be found or that does not work, I know for a fact you can make all menus disappear by calling window handles and writing API code and interacting with Windows operating system directly but that's more difficult.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide Unused Cells
    By jwatson1966 in forum Excel General
    Replies: 3
    Last Post: 10-14-2010, 07:24 PM
  2. hide unused cells/rows
    By mikej2009 in forum Excel General
    Replies: 2
    Last Post: 04-09-2010, 07:20 AM
  3. [SOLVED] How to hide unused cells when running accumulated totals
    By grano2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 04:05 PM
  4. How to hide unused cells when running accumulated totals
    By grano2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. How to hide unused cells when running accumulated totals
    By Kassie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. How to hide unused cells when running accumulated totals
    By grano2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. How to hide unused cells when running accumulated totals
    By grano2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. How to hide unused cells when running accumulated totals
    By grano2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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