Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Hiding Tool Bars

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does any know the code to hide all the tool bars , also if poss the start tool bar at the bottom and how to disable keys eg ctrl
    ??

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-27 11:21, brettvba wrote:
    Does any know the code to hide all the tool bars , also if poss the start tool bar at the bottom and how to disable keys eg ctrl
    ??
    Application.CommandBars("Standard").Visible = False

    Replace standard with the name of the toolbar that you want to hide.

    Regards,

    Gary Hewitt-Long

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Washington State
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    This will disable the control-c, control-v, and control-x shortcuts.

    Application.OnKey "^c", ""
    Application.OnKey "^v", ""
    Application.OnKey "^x", ""

    This restores them.

    Application.OnKey "^c"
    Application.OnKey "^v"
    Application.OnKey "^x"

    Disables the right click menu in the cell.

    CommandBars("Cell").Enabled = False


    Removes Excel Menu Bar
    CommandBars("Worksheet Menu Bar").Enabled = False

    Obviously set enable to TRUE before closing the workbook

    Hope this helps,

    Rick


  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you use the Fullscreen option this will hide the Task Bar.


    Sub minimalToolBars()

    Application.CommandBars("Standard").Visible = False
    Application.CommandBars("Formatting").Visible = False
    With Application
    .DisplayFormulaBar = False
    .DisplayStatusBar = False
    .DisplayFullScreen = True
    End With

    End Sub
    Regards,

    Gary Hewitt-Long

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Washington State
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I do not know if there is a way to hide the Start bar or not, and I would like to find someone that knew the code to disable the X on the application and the spreadsheet as well. I can disable the X on a userform, but if the other two are still active it doesn't make much sense

    Rick

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks fellas I can use that I much appreciated..

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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