Hiding Tool Bars

brettvba · Feb 27th, 2002, 11:21 AM

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 · Feb 27th, 2002, 11:34 AM

Quote:

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 · Feb 27th, 2002, 11:43 AM

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 · Feb 27th, 2002, 11:44 AM

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 · Feb 27th, 2002, 11:47 AM

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

brettvba · Feb 27th, 2002, 11:49 AM

Thanks fellas I can use that I much appreciated..

Feb 27th, 2002, 11:44 AM	#4
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 11:21 AM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	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 ??

Feb 27th, 2002, 11:43 AM	#3
RWinfield New Member Join Date: Feb 2002 Location: Washington State Posts: 33	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

Feb 27th, 2002, 11:47 AM	#5
RWinfield New Member Join Date: Feb 2002 Location: Washington State Posts: 33	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

Feb 27th, 2002, 11:49 AM	#6
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Thanks fellas I can use that I much appreciated..