vba courses london - Excel

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Excel

Gunaratnam has attended:
Excel Advanced course
Excel VBA course
Access Advanced course
Access Intermediate course

by - delegate Gunaratnam [4 posts] (2007 May 9 Wed, 14:31) Reply

i want to shaw the menu (which i have set up for my programm with button and drop down bar etc)

in full screen when open it in the excel, basically i want to hide formula bar, standared tool bar and other excel icones in the top and botton of the sheet.

RE: excel

by - trainer Carlos gold contributer [394 posts] (2007 May 23 Wed, 14:09) Edited on 2007 May 23 Wed, 14:10 Reply

To Show/Hide toolbars

Tools/Customize

In the Customize dialog box select Toolbars

Tick the toolbars you want to see on the application and click OK

In VBA code

Application.CommandBars("TheBarName").Visible = True OR False

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Display Text In a Msgbox On Multiple Lines

When displaying text in a MsgBox you may need to show it over multiple lines. To do this use:

vbCrLf

As in:

MsgBox "The System has detected an error." & vbCrLf & "Contact your System Administrator"

The first sentence in quotes will appear above the second in the MsgBox.

View all VBA hints and tips