Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Excel

vba courses london - Excel

ResolvedVersion Standard

Wed 9 May 2007, 14:31 Delegate Gunaratnam said...

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

Excel

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.

Wed 23 May 2007, 14:09 Edited on Wed 23 May 2007, 14:10 Trainer Carlos said...

RE: excel

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

vba courses london - Excel

Excel

RE: excel

VBA articles

VBA tip:

Count the Rows and Columns in a Selection