Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disable Customize option next to a tool bar from VB
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 |
#2
|
|||
|
|||
Disable Customize option next to a tool bar from VB
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Customize toolber tabs | Excel Discussion (Misc queries) | |||
disable customize option when right click on menu bar | Excel Discussion (Misc queries) | |||
How to disable smoothline option. | Charts and Charting in Excel | |||
how can i enable or disable the paste option in excel 2000 | Excel Worksheet Functions | |||
Disable "Save As" Option | Excel Discussion (Misc queries) |