disable toolbars

's Computer Specifications

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

's Computer Specifications

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)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to cause toolbars to be disable in a form	Chris Peel	Microsoft Outlook Form Programming	1	23rd Aug 2007 02:46 PM
Disable toolbars	=?Utf-8?B?YWNvcmVz?=	Microsoft Access Form Coding	5	8th Dec 2006 12:45 PM
How to disable toolbars	=?Utf-8?B?U3RldmU=?=	Microsoft Access	2	19th Mar 2004 08:12 PM
Re: How Do I Disable The Toolbars?	Joshua A. Booker	Microsoft Access Forms	0	19th Mar 2004 07:17 PM
Disable Toolbars... Permanently	Justin Swall	Microsoft Excel Misc	3	5th Feb 2004 02:28 AM