Sept 2002
Home Up Past Meetings Notes Tips Directory Links of Interest Site Map FAQs

Our Next Meeting: Wednesday, September 11,  2002
Note: we now meet on the Second Wednesday of each month.

We have a NEW URL:   www.excelsig.org
WiserWays still sponsors and maintains our web site.

6:30-7:00 pm 

General Questions and Problems from the Audience
Puzzler:
   How can I choose a font size of 5?    Can I do it with one click?

7:00-8:00 pm Making your own Toolbars.    
Writing your own Personal.xls workbook.
Attaching Toolbars to workbooks.

Note: The Topic: "Building a Simple Financial Cash flow Model.   An Oil Field Development case." was postponed to October.   The seminar was interested in toolbars after the puzzler.

8:00-8:10 pm

(Break) 
8:10-9:00 pm One Hour App: Make your own Add-In.

Why would you want to?   When you want to create a subroutine like the Font Size 5 from last month, and use it over and over in many workbooks, you ought to put it into an Add-In.    If you put user functions in a common workbook and use them in other workbooks, then you must manage links between workbooks.     On the other hand, if you put functions in an Add-In workbook, you never have to worry about links.

We will create an add-in to hold some of the financial functions we made for the cash flow model in the first hour.

Sample Data ] Notes ] Design Guide 97 ] Design Guide '02 ]

 

For questions or comments concerning content on this website: Stephen Rasey
Design of this site by Cheryl D. Wise
Copyright © 2000-2004 by WiserWays. All rights reserved.
Revised: 2005-07-10 01:08 .