
 =====================================================================
     XlsNames version 1.0
     MS Excel (5.0 or 7.0) add-in
     Create, change, delete, and undelete sheet-level names
 =====================================================================

     If you are familiar with Excel Names in general and use them
     in your spreadsheet models, you can skip the first topic
     (About Excel Names).

     If you have tried creating names with sheet-level scope and
     find it a tedious task, you can start reading from the third
     topic (Overview of This add-in) onwards or jump straight to
     Installation.  

 ***    CONTENTS

     1. About Excel Names
     2. Worksheet Names
     3. Overview of This add-in
     4. Installation and Removal
     5. Packing List
     6. Documentation
     7. Legal Matters
     8. Registration and Support
     9. About the Author


 *** 1. About Excel Names

     Do you really need names when working in Excel or can happily
     live without them and have your job done.  It depends on your
     working style, on how often you change your worksheet models
     and how complex they are.  If you use Excel occasionally for
     simple table formatting, enter formulas with the Function Wizard
     or by pointing and clicking the desired cells, and prefer the
     ad-hoc working style, most probably you will not need names at all.
     If you are more organised and maintain many workbooks with
     complex models and update them frequently, it is worth investing
     your time in Excel names.  Once you start using them, you will forget
     about cell references and start thinking in terms of the model you
     are working on.  This will make you more productive by saving the
     time you spend on trying to figure out the difference between
     relative and absolute references, or what will happen when you
     insert a row (column), or copy a formula.  It has always been better
     to concentrate on the contents, rather than on the tools used.

     For a more detailed overview of Excel names refer to this add-in's
     help file (xlsnames.hlp) and the Excel documentation.



 *** 2. Worksheet Names

     Once defined, names normally have book-level scope, meaning that
     they can be used anywhere in the workbook.  These names are available
     in the name box on the formula bar from any sheet in the workbook.

     You can also define special names that have sheet-level scope,
     meaning that they can be used only on the sheet where they are
     defined (referred to as worksheet names in the help file).
     These names are not visible in the name box on the formula bar
     or the Define Name dialog box from any other sheet in the workbook
     except the active sheet.

     When to use worksheet names?  If you have different worksheet models
     stored in a workbook, generally it is better to group the defined
     names by worksheets, rather than define them as book-level names.
     This way your list of defined names, displayed in the name box of
     the formula bar will be shorter and easier to use.  Suppose you
     choose a name from the drop-down list of the name box and it takes
     you to another worksheet, when the only thing you intended to do was
     to see the range this name refers to, thinking it is on the active
     worksheet.  It is better to keep the workbook names for ranges,
     formulas, or values, which you will use throughout the entire
     workbook, and define worksheet names for the different models
     in the worksheets.

     The arguments for using worksheet names are even stronger when you
     have similar model structures throughout the workbook.  With
     book-level names you have to think of defining different names
     for each worksheet, and the easiest way to do it is to start each
     Excel name with the worksheet name, which is almost defining the
     name as worksheet one.  Having the same names in some of the
     worksheets has it's own advantages.  You can consolidate your data
     based on categories not references or you can save a lot of time
     filtering lists using complex criteria if the names "Database",
     "Criteria", and "Extract" are defined.  The ranges they refer to
     will automatically show up in the Advanced Filter dialog box.



 *** 3. Overview of This add-in

     If you use Excel names in your worksheet models, or have decided
     to do it from now on, this add-in will make you more productive,
     by saving you a lot of time, and by allowing you to concentrate
     on the contents of your model rather than on the tools used to
     build it.

     Excel offers three ways to define a name:

     o  By typing the name in the Name box of the formula bar.  The name
        definition will refer to the selection on the active sheet.
     o  By using the Create Command (Insert Menu, Names Submenu) you
        name cells based on text in the border rows (columns) of the
        selection.
     o  By using the Define Command (Insert Menu, Names Submenu) you can
        enter the name's definition as a reference, value or formula.

     All names defined this way have book-level scope.  If you want to use
     names with sheet-level scope (called worksheet names in this add-in)
     you have to use the Define Command, entering the sheet name in front
     of the Excel name with the exclamation point (!) separating the two.
     If you want to use the Create Command to define worksheet names
     based on text in the border rows (columns) of the selection you
     can do it the following way:

     After you have created the names with book-level scope, change their
     definitions by entering the worksheet name and the exclamation point
     for each one in the Define dialog.  Now for each name created with
     the Create Command and changed with the Define Command you have a
     set of two names (one with book-level and another with sheet-level
     scope) referring to the same range of cells.  If for some reason you
     want to get rid of the book-level name you have to activate another
     sheet and use the Define dialog to delete it.  Does it sound
     complicated? And it's a great time-waster as well.

     With this add-in you can define worksheet names by using the new
     Create and Define Commands (Insert Menu, Worksheet Name Submenu) the
     same way as with the built-in commands.  You can do more than that by
     using the Change Command and the Undelete (Delete) Commands.

     To change a defined name in Excel you have to use the Define Command
     in a two step process, first changing and then deleting the old
     name.  If you have used that name in formulas, some #NAME? errors
     will appear in the worksheet.  The Change Command (Insert Menu,
     Worksheet Name Submenu) allows you to change a worksheet name in
     one step and avoid the #NAME? error.

     Have you tried Undo after deleting a name?  It simply doesn't work.
     This add-in stores the deleted worksheet names and their definitions
     (the worksheet, the name itself, and the value, formula, or cells it
     refers to) in a list, available during an Excel session.  It doesn't
     matter which workbooks you open and close, as far as you don't exit
     Excel, all the deleted worksheet names are available for undeleting.
     You can close a workbook, then change your mind, open it again, and
     undelete some of it's worksheet names.  The Undelete Command works no
     matter how you have deleted the name: by using the Delete Command of
     this add-in, or by pressing the Delete button in the Define worksheet
     names dialog.  



 *** 4. Installation and Removal

     System Requirements:

     Windows 3.1 or later
     Ms Excel 5.0 or 7.0

     Before You Proceed:

     Please read the terms and conditions ("License Agreement" and
     "Disclaimer of Warranty" in LICENSE.TXT) before installing the
     software.  If you do not agree to the terms and conditions described
     there in, please do not install and use the software and destroy all
     related files from your disk.  Starting the installation process
     constitutes acceptance to the terms and conditions of the "License
     Agreement" and "Warranty Disclaimer".

     To install the XlsNames add-in:

     o  Unzip the files to a desired directory or folder (if you haven't
        already done so).  If you want the context-sensitive help to be
        available for this add-in, both xlsnames.xla and xlsnames.hlp have
        to be in the same directory or folder.
     o  Start the Excel Add-In Manager from the Tools Menu,
        Add-Ins Submenu.
     o  Press the Browse button and locate the drive, directory or folder
        and filename (xlsnames.xla), and press the OK button.
     o  The "Worksheet Names" add-in will appear in the add-in
        Manager's list.
     o  Select the check box next to the "Worksheet Names" add-in.
     o  Press the OK button.
     o  All add-ins installed in Excel are active until you remove them.

     To remove the XlsNames add-in:

     o  Start the Excel add-in Manager.
     o  Clear the check box next to the "Worksheet Names" add-in.
     o  Press the OK button
     o  Next time you start Excel the "Worksheet Names" add-in will
        be removed.  However, all files will remain in the directory you
        put them initially, available for installation in the future.
        If you want to remove the XlsNames add-in from your hard disk
        simply delete the directory or folder containing the files.

 *** 5. List of Files

     XLSNAMES.XLA   The XlsNames add-in itself
     XLSNAMES.HLP   Documentation in Windows Help format
     README.TXT     You are reading it
     LICENSE.TXT    License Agreement and Warranty Disclaimer
     REGISTER.TXT   How to register and how much it will cost you
     FILE_ID.DIZ    Brief description for Bulletin Boards
     VENDOR.TXT     Information for Shareware Vendors and Distributors

 *** 6. Documentation

     For full documentation, including context sensitive help, press the
     Help button on any of the dialogs, displayed when this add-in
     commands are executed from the Insert Menu, Worksheet Name Submenu,
     or use the Help Command from the Insert Menu, Worksheet Name Submenu.

     Using the Contents and Search buttons under Windows 95 may load the
     Excel main help instead of the XlsNames help file Contents and Search
     windows.  Use the "Contents" link in the "See also" pop-up box
     in order to navigate successfully through the help file.



 *** 7. Legal Matters

     The XlsNames add-in is distributed as Shareware "try before you buy"
     software.  That means you are expected to pay a registration fee to
     the author in order to continue using the software beyond the initial
     trial period.  Your registration will encourage me to provide future
     enhancements for the XlsNames add-in.  This will also encourage me to
     release other quality software in the future as Shareware at
     affordable prices.

     I have made every effort to assure that the XlsNames add-in will
     perform in substantial compliance with the documentation supplied
     with the software.  However, the XlsNames add-in is distributed on
     "as is" basis without warranty of any kind.  The author does not
     warrant that the software will meet your requirements or that the
     operation of the software will be uninterrupted or error free.
     In no event shall the author be liable for any damages whatsoever
     resulting from loss of use, data, or profits arising out of or in
     connection with the use or performance of this software.

     For the full text of the "License Agreement" and "Disclaimer of
     Warranty" please refer to LICENSE.TXT.

     If you like the XlsNames add-in and find it useful please let me
     and other people know about it.  Feel free to pass it to friends
     and business associates, BBS's or user's groups.  In fact you are
     highly encouraged to do so subject to the limitations described
     in the "Limited License for Distribution" section of the
     "License Agreement".

 *** 8. Registration and Technical Support

     Thank you for choosing to register the XlsNames add-in.  It is your
     fees that will support me in enhancing this product in the future
     and develop other software for Shareware distribution.  As a
     registered user you are entitled to the following benefits:

     o  You are legal.
     o  Technical support by e-mail.
     o  Discounts on all future products developed by me.
     o  No more registration reminders when using the add-in. 

     The unregistered version of the XlsNames add-in is a fully
     functioning Excel add-in.  This way you can evaluate all the
     features of the software.  However, when you execute one of the
     commands XlsNames adds to the Excel menu structure a registration
     reminder from the help file may appear on the screen. Even I can
     not tell you how often this will happen as it is randomly controlled
     from the add-in itself.  Excel is not affected in any way by this
     registration reminder.  All you have to do is just close the help
     window (I hope you'll read it), or the dialog box that pops up
     and continue working.

     Any fee you may have paid to others (disk vendors, dealers, etc.)
     to obtain this version of the software was a fee for their copying
     and distribution services, rather than a payment for continued use
     of the add-in.  If you continue using XlsNames after the initial
     30-day trial period please register.  For detailed information on
     registration fees and how to register please refer to REGISTER.TXT.

     If you have any questions please direct them to the author.  Do not
     call Pik A Program, Inc. unless you want to inquire on prices,
     register by phone or obtain a written permission for distribution,
     subject to the terms and conditions described in the "Limited
     License for Distribution" section of the "License Agreement".



 *** 9. About the Author

     My name is Dimitar Minchev.  I live and work in Sofia, Bulgaria,
     Eastern Europe. After graduating the Technical University in
     Sofia I started my career back in 1976 as a COBOL programmer.
     In the 80s I had the chance to join the small team of IBM in
     Bulgaria and worked 7 years for Big Blue as a Systems Engineer.
     In the years that follow I gained a lot of practical experience
     working as DP Manager and Project Manager for various companies
     in the areas of Publishing and Wholesale and Distribution,
     including Shell Bulgaria Ltd.  In 1993 I decided to be on my own
     and have worked as a freelance consultant since.

     I have to admit that this is my first attempt to offer sofware
     for Shareware distribution.  The XlsNames was developed by me while
     working on a an Excel project for a distribution company here in
     Sofia for improving my personal productivity.  I find it useful and
     hope you will as well.   

     Your comments, suggestions, bug reports etc. will be highly
     appreciated.  You can contact me by e-mail at:

     dminchev@usa.net

     Thank you for reading so far.
