Couldn’t we just enumerate all the items in the CommandBars collection to retrieve a list of toolbar names? Yes, we could. The names shown in the menu are the same names you use in your scripts. No doubt one question that immediately pops into mind is this: how did we know this particular toolbar has the name Formatting? Well, if you click the View menu in Word and then click Toolbars you’ll see a list of the toolbars available. If we wanted to show the toolbar all we’d have to do is set the Visible property to True. To hide the toolbar we simply set the toolbar’s Visible property to False.
#WORD TOOLBAR HIDES CODE#
We then use this line of code to create an object reference to the Formatting toolbar, which is part of the Word CommandBars collection: Set objTool = objWord.CommandBars(“Formatting”) We begin by creating an instance of the Word.Application object and then setting the Visible property to True (just so we can see what’s going on). Set objTool = objWord.CommandBars(“Formatting”)Īs you can see, it’s a simple task – hide a toolbar – and an equally simple script. You want a script that can hide a specific toolbar in Microsoft Word, right? Well, how about this simple little script, which hides the Formatting toolbar: Set objWord = CreateObject(“Word.Application”)
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.But let’s get down to business.
Opens the help viewer for the associated application. Microsoft Visual Basic for Applications Help This is only available when a UserForm is active. Opens the Properties window so that you can view the properties of the selected control.ĭisplays the Object Browser, which lists the object libraries, the type library, classes, methods, properties, events, and constants that you can use in code, as well as the modules and procedures you defined for your project.ĭisplays or hides the Toolbox, which contains all of the controls and insertable objects (such as a Microsoft Excel Chart) available to your application. Stops execution of a program while it's running and switches to break mode.Ĭlears the execution stack module level variables and resets the project.ĭisplays the Project Explorer, which displays a hierarchical list of the currently open projects and their contents. Runs the current procedure if the cursor is in a procedure, runs the UserForm if a UserForm is currently active, or runs a macro if neither the Code window nor a UserForm is active. Restores the last text editing Undo actions if no other actions have occurred since the last Undo. Opens the Find dialog box and searches for the specified text in the Find What box. Inserts the contents of the Clipboard at the current location. Removes the selected control or text and places it on the Clipboard.Ĭopies the selected control or text onto the Clipboard. Saves the host document including the project and all of its components (forms and modules). The icon changes to the last object you added. Opens a menu so that you can insert one of the following objects to your active project. Toggles between the host application and the active Visual Basic document. If you want to display ToolTips for the toolbar buttons, you can select the Show ToolTips option on the General tab of the Options dialog box. You can click a toolbar button once to carry out the action represented by that button. Contains buttons that are shortcuts to some commonly used menu items.
0 kommentar(er)
