Hiding Tool Bars

[brettvba]

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
??

 

[gplhl]

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.

 

[RWinfield]

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

 

[gplhl]

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

 

[RWinfield]

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 :wink:

Rick

 

[brettvba]

Thanks fellas I can use that I much appreciated..