|
|
|
|
|
Description: |
This workbook shows how to create an interactive
add-in controlled by a toolbar |
|
|
|
|
|
The toolbar is created when the add-in is loaded,
and deleted when the add-in is closed. |
|
|
|
|
|
|
|
The add-in performs two functions: |
|
1) |
Shows today's date on pressing the smiley icon. |
|
2) |
Interactive control of the worksheet's zoom setting,
based on the file "mzoomer.xls". |
|
|
|
|
|
|
|
Contents: |
Description |
|
|
Create an add-in from this file |
|
|
Loading the add-in |
|
|
Unloading the add-in |
|
|
Instructions for using Zoomer |
|
|
Code overview |
|
|
|
|
Note: |
The functionality of this file as a workbook or as an add-in
is the same. |
|
|
|
|
|
|
Top |
|
|
|
|
|
|
|
Create an add-in from this file |
|
1) |
File > Save As > |
|
2) |
Change the "Save as type" to "Microsoft Excel Add-In (*.xla)" |
|
3) |
Browse to the directory where you want to save the add-in |
|
4) |
Click on "Save" |
|
Top |
|
|
|
|
|
|
|
|
|
|
Loading the add-in |
|
1) |
Tools > Add-Ins |
|
2) |
Click Browse, and go to where you saved the add-in. |
|
3) |
Select the check box next to it |
|
|
The description in the "Add-Ins" dialog box is: |
|
|
CommandBars and AddIn demo (based on mZoomer) |
|
4) |
Click OK
This automatically loads the toolbar |
|
|
|
|
|
Unloading the add-in |
|
1) |
Tools > Add-Ins |
|
2) |
Uncheck the box next to it.
This automatically deletes the toolbar |
|
|
|
|
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
Instructions for using Zoomer |
|
|
|
|
Use: |
Click on the "Zoomer" button to display the
dialog box. It has five buttons and a scrollbar. |
|
|
|
|
Fit Width: |
Fits the width of the current selection
to the screen |
|
100%: |
Sets the 100% zoom setting. |
|
75%: |
Sets the 75% zoom setting. |
|
Reset: |
Returns the screen to the setting you were
using before pressing "Zoomer" |
|
OK: |
Press this when you are satisfied with the
zoom setting |
|
|
|
|
|
|
|
Scroll Bar: |
When you click in the body of the scroll bar it
changes the the zoom setting by +/-10%. |
|
|
Clicking on the scroll bar's left or right arrows
changes the zoom setting by +/-1%. |
|
|
|
|
Benefit: |
Interactively see the effect of changes you make
to Excel's zoom setting |
|
|
|
|
Top |
|
|
|
|
|
