Disable Customize option next to a tool bar from VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

We use excel for our reports and for security reasons, we do not want to
give 'Open' option to our users.
We are able to disable the 'Open' menu option programmatically from VB. We
also want to eliminate the usage of 'Open' tool bar command. To do this, we
need to hide the standard tool bar, by default, when the excel file opens.

What is the way to do this from Visual Basic 6.0?
Thanks in advance
ourspt
 
Hi Ourspt

To hide the toolbar, try:

Application.CommandBars("Standard").Visible=False

To hide and disable the toolbar, try:

Application.CommandBars("Standard").Enabled=False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Excel Toolbars - how? 10
Custom Menu (not tool bar) 1
Disable macro selections under tools menu 1
QAT does not allow enough room for customization - please help 2
Using of Customized Tool Bar in another file 2
Custom tool bar 2
Tool bars 10
Missing worksheet menu bar Excel 2003 5

Back
Top