ExcelBanter - disable toolbars

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - disable toolbars (https://www.excelbanter.com/excel-programming/392316-disable-toolbars.html)

pswanie

disable toolbars

what code would i enter to have the standard, formating, drawing toolbars be
disabled when a work book open? (right click on edit.... etc)

Mike H

disable toolbars

Hi,

Don't forhget to enable them in workboo_before close

Private Sub Workbook_Open()
Application.CommandBars("standard").Enabled = False
Application.CommandBars("format").Enabled = False
Application.CommandBars("drawing").Enabled = False
End Sub

Mike

"pswanie" wrote:

what code would i enter to have the standard, formating, drawing toolbars be
disabled when a work book open? (right click on edit.... etc)

All times are GMT +1. The time now is 02:49 PM.