ABOUT BOB'S MACROS ------------------ Bob's Macros are designed to save you time in your use of Microsoft Excel and eliminate repetitious tasks. The macros will increase your productivity every time you are in Excel. The commands will save you anywhere from a few seconds to a few minutes each time you use them. Added up over the course of a year that's a lot of time savings. You do not have to be an expert to use the macros. They are designed for use by everyone. There are over 100 macros that comprise Bob's Macros. These are macros that I use personally in my job and I thought it would be useful to you. There is more to Bob's Macros than the list of macros that appear when you click on Bob's Icon. Bob's Macros adds commands to the Excel menus found at the top of the screen, and to the pop up menus when you press the right mouse button. These pop up additions you will find very useful in developing spreadsheets. The macros range from the simple to the very very powerful. All are designed for ease of use. And, by the time you read this, they will probably be a lot more than 100 macros, plus enhancements to the original set of macros. So, if you do register, I recommend that you also ask for the latest release. By clicking on Bob's Icon or by selecting "Bob's Macros" from the toolbar menu, you can see a list of almost all the commands. You can access many of the macros directly from the Excel Menus. Also, additional commands have been added to the Excel pop-up menus that are not listed on the macro list. Another nice feature is the repeat icon. If you run a macro from the macro list, this icon is automatically customized to repeat the command! And, if you highlight the icon, it reminds you what the icon is set to do. Just another way to save you time. Furthermore, you can assign any of the macros to icons or let Bob's Macros assign them to an icon for you! Please let me know what you think of the macros and any improvements that are needed. I use the macros every day and look forward to hearing your comments. And, If you think of a macro you would like to have added, let me know when you register. Sincerely, Bob Flanagan, Macro Systems INSTALLATION ------------ Installation of Bob's Macros is very easy: STEP 1 If you are using Excel 5, copy the file BOBSMACS.XL5 to your Excel startup directory. If you are using Excel 4, copy the file BOBSMACS.XL4 to your startup directory. DO NOT COPY BOTH FILES. The startup directory is almost always named "XLSTART" and is almost always a subdirectory of your Excel directory. By putting this in your startup directory, it is loaded each time you load Excel. This is extremely important, as Bob's Macros are designed to help you all the time while you are in Excel. And if they are not loaded when you need them, you won't get as much benefit. In case you are wondering, yes you can put the the files in a directory other than your startup directory. But, we don't recommend it for obvious reasons. STEP 2 Copy the file BOBSMACS.HLP to your Windows directory. STEP 3 Try them and you'll like them. Then register! HOW TO REGISTER --------------- When you register your copy of Bob's Macros, Macro Systems will send you a registration code that will allow full use of Bob's Macros all the time. Register your copy of Bob's Macros by sending the form below along with your payment to: Macro Systems 1008 Lawndale Road Wilmington, DE 19810 You may pay by check or cash. If you are paying from outside the U.S., you may pay only by cash, by a check drawn on a U.S. bank or by an international money order. You may also charge your order to your Compuserve account by typing GO SWREG. Select product #3553 for registration only or #3554 for registration and the latest version. The cost via Compuserve is 15% higher due to their service fee. However, you will get the registration code and latest release a lot faster. REGISTRATION FORM FOR Bob's Macros ---------------------------------- Number of copies being registered _______ times $ 19 = $ _______ Number of manuals and disks needed ______ times $ 6 = $ _______ TOTAL AMOUNT $ _______ Disk size (please circle) 3 1/2" 5 1/3" Note: Purchase of manuals and disks is optional, but does insure that you have the latest release, with any new macros that have been added along with enhancements to the original ones. Payment method (please circle): Check Cash Money Order Mailing address (please print): Name ___________________________________ Address ___________________________________ ___________________________________ City/State/Province ___________________________________ Country/Postal code ___________________________________ Suggestions for new macros: _______________________________________________ _______________________________________________ _______________________________________________ _______________________________________________