Word Document Properties



Download 8,82 Mb.
Pdf ko'rish
bet48/207
Sana16.03.2022
Hajmi8,82 Mb.
#496217
1   ...   44   45   46   47   48   49   50   51   ...   207
Bog'liq
VBA For Dummies 5th Ed.pdf ( PDFDrive )

Figure 2-7:
Make a
program
quick-launch
by using the
Macro
Options
dialog box.
42
Part I: An Overview of VBA 
06_046500 ch02.qxp 12/5/06 5:33 PM Page 42


an Office 2007 product that sports the Ribbon interface, you can’t easily add
anything to the Ribbon, so this section isn’t for you (see the “Working with
the New Ribbon Interface” section of Chapter 12 for details on adding buttons
to the Ribbon interface using VBA). Using this method means that all you
have to remember to do is to look at the toolbar.
Many people place custom buttons on the same toolbars that the application
uses for other purposes. This is fine if you don’t mind seeing the toolbar
grow longer and longer, right off the right side of the screen. It’s better to
create a custom toolbar so that you can show or hide the buttons associated
with your programs when you need them.
To add a VBA program to a toolbar, you can begin by creating a custom tool-
bar for the task or selecting an existing toolbar. The 
SayHello
example uses
an existing toolbar, Standard, to speed things up. The Standard toolbar is pro-
vided with just about every Windows application that uses VBA, but you
might need to use another toolbar. The following steps show how to add a
program to your toolbar:
1. Right-click in the toolbar area, and then choose Customize from the
context menu that appears.
The Customize dialog box appears.
2. Select the Commands tab and scroll through the Categories list until
you find Macros.
Figure 2-8 shows that you have two options for adding macros to your
toolbar — as a menu item or as a button.
Figure 2-8:
Add your
program to
the toolbar
by using
either a
button or a
menu item.
43

Download 8,82 Mb.

Do'stlaringiz bilan baham:
1   ...   44   45   46   47   48   49   50   51   ...   207




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©hozir.org 2024
ma'muriyatiga murojaat qiling

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish