From jacobson@math-cs.cns.uni.edu Wed Oct 1 16:01:12 2003 Date: Wed, 01 Oct 2003 16:00:44 -0500 (CDT) From: Mark Jacobson To: 810-022-01@uni.edu Subject: [810-022-01] Three Toolbars for Friday October 3rd... Tips... Hi 022 MASI students (VBA and Macros) The following note (answer to a Hobbit) may be useful to everyone. It clarifies where in the book you can look for practice and background on the toolbars assignment, and that the assignment is exactly as the two sheets (three pages) handout explains. Mark ---------- Forwarded message ---------- Date: Wednesday, 1 October 2003 08:35 a.m. (CDT) From: Mark Jacobson To: FrodoBaggins@MiddleEarth.com Subject: Re: Toolbars question On Wednesday, 1 Oct 2003 FrodoBaggins@MiddleEarth.com wrote: > What exactly do we have to do for our assignment that is due on Friday? Hello Frodo Gollum Baggins, The Friday assignment is to make a toolbar that has six different buttons on it. It will be called the SHOW/HIDE OPTIONS FGB or something like that, with the FGB initials of yours making it unique name, so it is easier for me to grade all these on one machine. A button that shows or hides the GRIDLINES whenever it is clicked. A button to show or hide the FORMULAS when clicked. A button to show or hide the vertical scrollbar when clicked. "" "" show or hide the horizontal scrollbar. "" "" show or hide the row and column headers. "" "" show or hide the sheet tabs. In case you do not have the handout (two different sheets) that makes all this clear, I will tape a copy or two to my office door, WRT 106, in case I am not here when you stop by to get the handout. The handout makes it all clear about the above toolbar, and includes directions and screen snapshots of what it looks like and so on. The Reed Jacobson textbook is very helpful for this assignment! Excel 2002 VISUAL BASIC For Applications Step by Step is just as its title states. A Step by Step hands-on tutorial for how to do the toggle macros and the Tools menu Options and everything about making a custom toolbar and custom toolbar buttons. Pages 14 and 15 explain how to create the show and hide gridlines MACRO, by recording and then modifying it to add the NOT operator. This is exactly one of the six macros you need to make! ------- And the other FIVE macros are basically identical to that first macro, explained on pages 14 and 15, except they will deal with Sheet Tabs or Formulas or Scroll Bars, etc. instead. Chapter 9 - Pages 182 to 201 covers all you need to know about creating a custom toolbar. Creating Custom Toolbars and Menus ------ Pages 184-192 Creating Custom Command Buttons --------- Pages 192-202 Page 182 has a great picture of the Modify Selection option in Customize, with a reference to Page 187 where you actually do the Zoom In and Zoom Out custom buttons. My handouts (3 pages, but maybe on two sheets, one is front and back) explain and illustrate all the rest. The best way to do this assignment, is just to do the step by step practices from Chapter One and Chapter 9 to prepare and get the feel of it all. The best way to prepare and learn is to DO the book exercise, which is very clear and step by step explained. Then do the assignment from my handouts, and come for help or send email if you have trouble. The 2nd part of the assignment is just to make the MOVE OBJECTS FGB and the ALIGN OBJECTS FGB two toolbars, which will be made up of buttons from the DRAWING toolbar, and do not even require you to write or record any macros! The 2nd part is all explained on one of the 3 pages of the handout. --- The SHOW/HIDE OPTIONS FGB toolbar is explained on one sheet, front and back, so it is two pages, but is one ONE SHEET. --------- Good luck and stop in if you need any help or demonstration of what to do! Mark