vba courses london - Personal toolbar button

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

Resolved · Low Priority · Version Standard

Personal toolbar button

Helena has attended:
Excel VBA course
Excel VBA Advanced course

by - delegate Helena [1 post] (2007 May 23 Wed, 15:30) Reply

How do I add a personal toolbar button with a macro?

RE: Personal toolbar button

by - trainer Richard platinum contributer [761 posts] (2007 Jun 8 Fri, 10:36) Reply

Hi Helena

Follow these steps:

- Right click any toolbar, choose CUSTOMISE
- Commands Tab, then MACROS under Categories
- Drag the smiley face onto your toolbar
- Right click on the smiley face on the toolbar, and choose Assign macro (You can also edit the button image from that menu).

Regards

Richard

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

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips