Disable Customize option next to a tool bar from VB

[ourspt]

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

[Norman Jones]

Hi Ourspt

To hide the toolbar, try:

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

To hide and disable the toolbar, try:

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


---
Regards,
Norman



"ourspt" <[email protected]> wrote in message
news:[email protected]...
> 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