vba courses london - excel

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

vba courses london - Excel

resolvedResolved · Low Priority · Version Standard

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.

Edited on Wed 23 May 2007, 14:10

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

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

VBA tip:

Use GoTo to Select A Cell With VBA

To select a certain cell on a Worksheet you can use:

Application.Goto Reference:=Range("V300")

or more simply

Range("V300").Select

If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:

Application.Goto Reference:=Range("V300"), Scroll=True

View all VBA hints and tips


Server loaded in 0.05 secs.