TAILIEUCHUNG - Excel 2002 Power Programming with VBA phần 8

Danh sách sau đây tóm tắt những cách mà bạn có thể tùy biến thanh công cụ trong Excel: ✦ Hủy bỏ các điều khiển tích hợp trong thanh công cụ. Bạn có thể loại bỏ các điều khiển mà bạn không bao giờ sử dụng và miễn phí một vài điểm ảnh không gian màn hình. ✦ | 654 Part VI Developing Applications Toolbar Manipulations The following list summarizes the ways in which you can customize toolbars in Excel Remove controls from built-in toolbars. You can get rid of controls that you never use and free up a few pixels of screen space. Add controls to built-in toolbars. You can add as many controls as you want to any toolbar. These controls can be custom buttons or buttons from other toolbars or they can come from the stock of controls that Excel provides. Create new toolbars. You can create as many new toolbars as you like with toolbar controls from any source. Change the functionality of built-in toolbar controls. You do this by attaching your own macro to a built-in control. Change the image that appears on any toolbar control. Excel includes a rudimentary but functional toolbar button editor although there are several other image-changing techniques. You can perform these customizations manually by using the Customize dialog box. This dialog box can be displayed using a number of different commands select View Toolbars Customize select the Tools Customize command or right-click any toolbar and choose Customize. In addition you can customize toolbars by writing VBA code. Note Don t be afraid to experiment with toolbars. If you mess up a built-in toolbar you can easily reset it to its default state. Just access the Customize dialog box and click the Toolbars tab. Then select the toolbar in the list and click the Reset button. How Excel Handles Toolbars Before you start working with custom toolbars it s important to understand how Excel deals with toolbars in general. You may be surprised. Storing toolbars Toolbars can be attached to XLS worksheet or XLA add-in files which makes it easy to distribute custom toolbars with your applications see Distributing toolbars later in this chapter . You can attach any number of toolbars to a workbook. When the user opens your file the attached toolbars automatically appear. An exception .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.